blocks|key|623419|text|mysqldump可以接受一个tbl_name参数，这样它就只备份给定表。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|623420|mysqldump+-u+-p+yourdb+yourtable+>+c:\backups\backup.sql|code-block|syntax|javascript|623421|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html^0|0|9|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

<a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html" rel="noreferrer">mysqldump</a> can take a tbl_name parameter, so that it only backups the given tables.

<pre><code>mysqldump -u -p yourdb yourtable &gt; c:\backups\backup.sql
</code></pre>

blocks|key|839322|text|我们可以获取具有任何给定条件的表的mysql转储，如下所示|type|unstyled|depth|inlineStyleRanges|entityRanges|data|839323|mysqldump+-uusername+-p+-hhost+databasename+tablename+--skip-lock-tables|code-block|syntax|javascript|839324|如果我们想在表中添加一个特定的where条件，那么我们可以使用以下命令|839325|mysqldump+-uusername+-p+-hhost+databasename+tablename+--where="date=20140501"+--skip-lock-tables|839326|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

We can take a mysql dump of any particular table with any given condition like below

<pre><code>mysqldump -uusername -p -hhost databasename tablename --skip-lock-tables
</code></pre>

If we want to add a specific where condition on table then we can use the following command

<pre><code>mysqldump -uusername -p -hhost databasename tablename --where="date=20140501" --skip-lock-tables
</code></pre>

blocks|key|839440|text|您可以使用以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|839441|此示例对sugarcrm数据库进行备份，并将输出转储到sugarcrm.sql|839442|#+mysqldump+-u+root+-ptmppassword+sugarcrm+>+sugarcrm.sql

#+mysqldump+-u+root+-p[root_password]+[database_name]+>+dumpfilename.sql|code-block|syntax|javascript|839443|sugarcrm.sql将包含drop+table、create+table和insert命令，用于sugarcrm数据库中的所有表。以下是sugarcrm.sql的部分输出，显示了accounts_contacts表的转储信息：|839444|--|839445|--表accounts_contacts的表结构|offset|length|style|CODE|839446|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;

--|839447|entityMap^0|0|0|0|0|0|3|H|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|11|8|@$O|12|P|13|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

You can use this code:

This example takes a backup of sugarcrm database and dumps the output to sugarcrm.sql

<pre><code># mysqldump -u root -ptmppassword sugarcrm &gt; sugarcrm.sql

# mysqldump -u root -p[root_password] [database_name] &gt; dumpfilename.sql
</code></pre>

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:

--

<h2>-- Table structure for table <code>accounts_contacts</code></h2>

<pre><code>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;

--
</code></pre>

blocks|key|839525|text|您可以从命令行使用mysqldump：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|839526|mysqldump+-u+username+-p+password+dbname+tablename+>+"path+where+you+want+to+dump"|839527|您还可以使用MySQL工作台：|839528|转到左侧>数据导出>选择架构>选择表，然后单击导出|839529|entityMap^0|9|9|0|0|2A|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|T|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|U|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|M|$]]

You can either use <code>mysqldump</code> from the command line:

<code>mysqldump -u username -p password dbname tablename &gt; "path where you want to dump"</code>

You can also use MySQL Workbench:

Go to left > Data Export > Select Schema > Select tables and click on Export

blocks|key|839584|text|只需使用mysqldump+-u+root+database+table，或者如果使用口令mysqldump+-u+root+-p+pass+database+table|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|839585|entityMap^0|4|W|19|14|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

just use <code>mysqldump -u root database table</code>
or if using with password <code>mysqldump -u root -p pass database table</code>

By default, <code>mysqldump</code> takes the backup of an entire database. I need to backup a single table in MySQL. Is it possible? How do I restore it?

How to take backup of a single table in a MySQL database?

默认情况下，mysqldump会备份整个数据库。我需要在MySQL中备份一个表。有可能吗？我如何恢复它？

问如何备份MySQL数据库中的单个表？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何备份MySQL数据库中的单个表？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何备份MySQL数据库中的单个表？
EN