mysqldump
bitscn.com#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]
1. backup a single database:
this example takes a backup of sugarcrm database and dumphotoshop/ target=_blank class=infotextkey>ps 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:
 代码如下 复制代码
--
-- table structure for table `accounts_contacts`
--
drop table if exists `accounts_contacts`;
set @saved_cs_client     = @@character_set_client;
set character_set_client = utf8;
create table `accounts_contacts` (
`id` varchar(36) not null,
`contact_id` varchar(36) default null,
`account_id` varchar(36) default null,
`date_modified` datetime default null,
`deleted` tinyint(1) not null default '0',
primary key  (`id`),
key `idx_account_contact` (`account_id`,`contact_id`),
key `idx_contid_del_accid` (`contact_id`,`deleted`,`account_id`)
) engine=myisam default charset=utf8;
set character_set_client = @saved_cs_client;
--
-- dumping data for table `accounts_contacts`
--
lock tables `accounts_contacts` write;
/*!40000 alter table `accounts_contacts` disable keys */;
insert into `accounts_contacts` values ('6ff90374-26d1-5fd8-b844-4873b2e42091',
'11ba0239-c7cf-e87e-e266-4873b218a3f9','503a06a8-0650-6fdd-22ae-4873b245ae53',
'2008-07-23 05:24:30',1),
('83126e77-eeda-f335-dc1b-4873bc805541','7c525b1c-8a11-d803-94a5-4873bc4ff7d2',
'80a6add6-81ed-0266-6db5-4873bc54bfb5','2008-07-23 05:24:30',1),
('4e800b97-c09f-7896-d3d7-48751d81d5ee','f241c222-b91a-d7a9-f355-48751d6bc0f9',
'27060688-1f44-9f10-bdc4-48751db40009','2008-07-23 05:24:30',1),
('c94917ea-3664-8430-e003-487be0817f41','c564b7f3-2923-30b5-4861-487be0f70cb3',
'c71eff65-b76b-cbb0-d31a-487be06e4e0b','2008-07-23 05:24:30',1),
('http://www.hzhuti.com/android/xt702/','79d6f6e5-50e5-9b2b-034b-487ce1dae5af',
'7b886f23-571b-595b-19dd-487ce1eee867','2008-07-23 05:24:30',1);
/*!40000 alter table `accounts_contacts` enable keys */;
unlock tables;
mysql mysqldump命令实现数据导出导入 点击查看
更多详细内容请查看：http://www.111cn.net/database/mysql/42189.htm
bitscn.com