Backup and restore of MySQL

MySQL backup and restore is done using the mysqldump, MySQL, and source commands.
backup and restore of MySQL under 1.win32
1.1 Backup
Start Menu | Run | cmd | Go to Bin folder with "Cd/program files/mysql/mysql Server 5.0/bin" command | Use "Mysqldump-u user name-p databasename >exportfilename" to export the database to a file, such as Mysqldump-u root-p voice>voice.sql, and then enter the password to start the export.

1.2 Restore
Enter MySQL command line Client, enter the password, enter the "mysql>", enter the command "show databases;", enter to see what database; Create the database you want to restore, enter the Voice; ", enter; switch to the newly created database, enter" use voice; ", carriage return, import data, enter" source voice.sql; ", carriage return, start import," mysql> "again, and the restore succeeds without prompting the error.

backup and restore of MySQL under 2.Linux
2.1 Backup
[Root@localhost ~]# Cd/var/lib/mysql (go to MySQL library directory, adjust the directory according to your MySQL installation situation)
[Root@localhost mysql]# mysqldump-u root-p voice>voice.sql, enter the password.

2.2 Restore
Law One:
[Root@localhost ~]# mysql-u root-p return, enter the password, enter the MySQL console "mysql>", with 1.2 restore.

Law II:
[Root@localhost ~]# Cd/var/lib/mysql (go to MySQL library directory, adjust the directory according to your MySQL installation situation)
[Root@localhost mysql]# mysql-u root-p voice<voice.sql, enter the password.

Backup and restore of MySQL