Template: mysqldump-h ip-u user-p option Dbname>d:\db.sql
Option:-F indicates that there is an error when continue-D represents--no-create-db,-N for--no-data,-T for--no-create-info, and-R for export function and procedure.
To export only table structures:
Mysqldump-udb_user-p Dbname-d–trigger=false
To export only stored procedures:
Mysqldump-f-rtdn-triggers=false
To export only triggers:
Mysqldump-f-tdn–triggers
To export only events:
Mysqldump-f-etdn–triggers=false
Export Data only:
Mysqldump-f–single-transaction–triggers=false-t
Backing up tables and data in a library
Mysqldump-udb_user-p dbname | Dbname_bak.sql
Or
Mysqldump-udb_user-p dbname | gzip > dbname_bak.sql.gz
Backing up tables, data, and stored procedures in a library
Mysqldump-udb_user-p Dbname-r | Dbname_bak.sql
Or
Mysqldump-udb_user-p Dbname-r | gzip > dbname_bak.sql.gz
If an error occurs during the backup stored procedure:
Mysqldump:db_user have insufficent privileges to SHOW CREATE PROCEDURE ' sp_name '!
Workaround:
Grant Select on Mysql.proc to [email protected]
Restore the full library
Mysql-udbuser-p dbname < Dbname_bak.sql
Or
Gzip < dbname_bak.sql.gz | Mysql-udbuser-p dbname