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

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

After restoring a SQL Server database, it show a status of “Loading”

Getting the database out of LOADING state When restoring multiple backups, each backup needs...

Change the DNS servers for the network interfaces on my Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...

Change the DNS servers for the network interfaces on Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...

Change the root password for a *nix server

In order to change the root password login to the server as root and type the following, then...

ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated...