mysql mysqldump数据库备份与还原

mysqldump是mysql一个数据库常用工具，我们经常用它来实现数据和备份如，数据导入导出本文章来介绍最基本数据库导出与表导现的代码] #dump　名　>数据库备份名 #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.sqlrestore:# mysql -u root -p[root_password] [database_name] 1. Backup a single database:This example takes a backup of sugarcrm database and dum 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),('7dab11e1-64d3-ea6a-c62c-487ce17e4e41','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; 点击查看