-- Dump all databases and all tables (option "-A" is similar to "--all-databases")
mysqldump -u [username] -p[user_password] -A > [dump_filename]
-- Example, please note (NO SPACE between -p and your password)
mysqldump -u root -pmypass -A > full_dumb.sql
-- Dump single database
mysqldump -u [username] -p[user_password] [database_name] > [dump_filename]
-- Example
mysqldump -u root -pmypass dbshopping > dbshopping_dumb.sql
更新:
-- MySQL Enterprise Backup Syntax
mysqlbackup --user[username] --password=[user_password] --backup-dir=[backup_directory] --databases=[database_list] backup
-- Example Command
mysqlbackup --user=root --password=mypass --backup-dir=G:\mysql-enterprise-backup-directory --databases=dbshopping backup
我不是“MySQL 企业备份”方面的专家,但它对我来说效果很好......
您还可以从“mysql”数据库验证备份历史和/或进度
SELECT * FROM mysql.backup_progress;
SELECT * FROM mysql.backup_history;
获取 MySQL 转储的语法:
更新:
我不是“MySQL 企业备份”方面的专家,但它对我来说效果很好......
希望这可以帮助你...