备份命令格式

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]


例子

备份一个数据库
mysqldump -u root -ploh -hlocalhost jbb > dumpfilename.sql

备份多个数据库
# mysqldump -u root -ptmppassword --databases bugs sugarcrm > bugs_sugarcrm.sql

备份所有数据库
# mysqldump -u root -ptmppassword --all-databases > /tmp/all-database.sql

恢复数据库
# mysql -u root -ptmppassword sugarcrm < /tmp/sugarcrm.sql
# mysql -u root -p[root_password] [database_name] < dumpfilename.sql


一个命令把本地database恢复到remote的database
[local-server]# mysqldump -u root -ptmppassword sugarcrm | mysql \
                 -u root -ptmppassword --host=remote-server -C sugarcrm1
[Note: There are two -- (hyphen) in front of host]