How to back up the MySQL database should say that the general database has backup requirements, MySQL backup database is very simple, but on the internet foggy, it should be I am not familiar with MySQL database. Target: Back up the MySQL database in the native to the MyDatabase database in the native-the full copy of a database. #1. C:\Program Files\mysql\mysql Server 5.0\bin>mysqldump-u root-p Mysql>backup_database.sql Enter Password: ******** (password for your root account)After completion, there is a backup_database.sql database file generated #2 the path C:\Program files\mysql\mysql Server 5.0\bin. Root login MySQL client, set up the target database MyDatabase, #3. C:\Program Files\mysql\mysql Server 5.0\bin>mysql-u root-p Yourdatabase<backup_database.sql enter Password: ******** (password for your root account) #4. Completed, (login to the MySQL client, use the show tables command to check if the structure and table in Yourdatabase are identical to the structure and table in the MySQL database.
