mysql如何备份表_如何在MySQL数据库中备份单个表？

You can use this code:

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.sql

The 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;

--