Backing up and restoring a MySQL database from the command line

. Shell into your box as root, then:
mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql

You will be prompted for your database password and then the DATABASE will be dumped to a plain-text file called FILENAME.mysql.
The resulting file, FILENAME.mysql, is a full backup with which you can fully restore your database in case of problems.

Restoring via the command line
1. Drop the database
mysqladmin -u USERNAME -p drop DATABASE

2. Recreate the database
mysqladmin -u USERNAME -p create DATABASE

3. Import the backup data
mysql -u USERNAME -p DATABASE < FILENAME.mysql

  • Email, SSL
  • 0 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Related Articles

redirect using .htaccess

1) Temporary Redirect : Redirect temp / http://www.test.com This will redirect...

Reset the SQL Server ‘sa’ user password?

Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on...

Export the data from different tables in our shared SQL environment?

Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases...

Restore a database on SQL Server using .mdf, .ldf and .ndf files?

You need to attach the database rather than perform a restore. Using Enterprise Manager: Expand...

Create PostgreSQL user account

It is advisable to run PostgreSQL under a separate user account. This user account should only...