Command backup and restore MySQL database

Restore a database: mysql-h localhost-u root-p123456 Www<c:/www.sql

Back up a database: mysqldump-h localhost-u root-p123456 www > d:/www2008-2-26.sql

Backup data:

The code is as follows	Copy Code
Mysqldump-u User name-p password database name > Xx.sql

Cases

Start Menu | Run | cmd | Access the Bin folder using the "Cd/program files/mysql/mysql Server 5.0/bin" command | Export the database to a file, such as Mysqldump-u root-p Voice>voice.sql, using the Mysqldump-u user name-p databasename >exportfilename, and then enter the password to start exporting

When the volume of data is large, you can use gzip compression

The code is as follows	Copy Code
Mysqldump-u User name-p password database name | gzip > XX.sql.gz

Recover data:

The code is as follows	Copy Code
Mysql-u User name-p password database name < Xx.sql

Cases

into the MySQL command line Client, enter the password, enter the "mysql>", enter the command "show databases;", carriage return, see what some database; Create the database you want to restore, enter "Create db Voice; ", carriage return; switch to the newly established database, type" use voice; ", enter the data, enter" source voice.sql; ", carriage return, start the import, reappear" mysql> "and restore success without prompting for an error.

Recovering directly from gzip compressed files

The code is as follows	Copy Code
Gzip < XX.sql.gz | Mysql-u User name-p password database name

Cases

To back up with the mysqldump command:
enter in the Command Prompt window (note that the MySQL command line Client window is not MySQL).

The code is as follows	Copy Code
Mysqldump-hlocalhost-uroot-proot Temp > Temp_2011.sql Mysqldump-hlocalhost-u Root-proot Temp > Temp_2011.sql Mysqldump-h localhost-u Root-proot Temp > Temp_2011.sql

First enter the directory where MySQL wants to store the backup files (easy to store the generated *.sql files).