#mysqldump 数据库名 >数据库备份名
#mysqldump -A -u用户名 -p密码 数据库名>数据库备份名
#mysqldump -d -A --add-drop-table -uroot -p >xxx.sql
导出整个数据库database
代码如下 | 复制代码 |
mysqldump –opt -uroot -ppassword database > dump.sql |
导出单个数据表table
代码如下 | 复制代码 |
mysqldump –opt –add-drop-table -uroot -ppassword database table > dump.sql |
国外网站数据导入导出说明
For the impatient, here is the quick snippet of how backup and restore MySQL database using mysqldump:
代码如下 | 复制代码 |
backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql |
1. Backup a single database:
This example takes a backup of sugarcrm database and dumps the output to sugarcrm.sql
代码如下 | 复制代码 |
# mysqldump -u root -ptmppassword sugarcrm > sugarcrm.sql |
# mysqldump -u root -p[root_password] [database_name] > dumpfilename.sqlThe sugarcrm.sql will contain drop table, create table and insert command for all the tables in the sugarcrm database. Following is a partial output of sugarcrm.sql, showing the dump information of accounts_contacts table:
代码如下 | 复制代码 |
-- DROP TABLE IF EXISTS `accounts_contacts`; -- LOCK TABLES `accounts_contacts` WRITE; |
mysql mysqldump命令实现数据导出导入 点击查看