MySQL Backup Database FAQ

If you encounter mysqldump:unknown option '--no-beep ', you can add--no-dafaults

No semicolon required at end of command

Mysqldump--no-defaults-uroot-  p--databases S8 > S888888.sql

1. Export all databases

This command exports all databases, including the system database

Mysqldump-uroot-proot--all-databases >/tmp/all.sql

2. Export all data for DB1, DB2 two databases

Mysqldump-uroot-proot--databases db1 DB2 >/tmp/user.sql

3. Export only table structure does not export data,--no-data

Mysqldump-uroot-proot--no-data--databases db1 >/tmp/db1.sql

4. Create a database with an export file

　

# On the command line Mysql–uroor–p Db1.sql < DB1

stored procedure generates 1 million data: [SQL] View plain copybegin  DECLARE i INT;  START TRANSACTION;  SET I=0;  While I<1000000 does      INSERT into T_user VALUES (Null,concat (i+1,'@xxg. com '), i+1);      SET i=i+1;  END while;  COMMIT;  END  

stored procedure generates 1 million data

MySQL Backup Database FAQ