mysql 备份多个表_MySQL数据库备份多个数据表 | Byrd's Weblog

[root@Mysql ~]# /usr/local/mysql/bin/mysqldump -uroot -p'admin' mysql user >/backup/user-tables-$(date +%F).sql

[root@Mysql ~]# /usr/local/mysql/bin/mysqldump -uroot -p'admin' mysql servers user>/backup/servers-user-tables-$(date +%F).sql

[root@Mysql ~]# egrep -v "^$|^--|\*" /backup/servers-user-tables-2014-06-05.sql

DROP TABLE IF EXISTS `servers`;

CREATE TABLE `servers` (

`Server_name` char(64) NOT NULL DEFAULT '',

`Host` char(64) NOT NULL DEFAULT '',

`Db` char(64) NOT NULL DEFAULT '',

############################省略############################

`Owner` char(64) NOT NULL DEFAULT '',

PRIMARY KEY (`Server_name`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

LOCK TABLES `servers` WRITE;

UNLOCK TABLES;

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',

`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',

`Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',

############################省略############################

`max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',

`plugin` char(64) COLLATE utf8_bin DEFAULT '',

`authentication_string` text COLLATE utf8_bin,

`password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',

PRIMARY KEY (`Host`,`User`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';

LOCK TABLES `user` WRITE;

UNLOCK TABLES;

[root@Mysql ~]#