备份MYSQL数据表结构与数据库结构教程.docVIP

备份MYSQL数据表结构与数据库结构教程 下面给各位介绍一篇备份MYSQL数据表结构与数据库结构教程,希望此教程能帮助到各位哦,有兴趣了解mysql备份数据表结构的朋友会带来帮助哦. 备份MYSQL数据表结构: [root@Mysql ~]# /usr/local/mysql/bin/mysqldump -uroot -padmin -d mysql servers/backup/mysql-structure-tables-$(date +%F).sql [root@Mysql ~]# egrep -v ^$|^--|* /backup/mysql-structure-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 , `Username` char(64) NOT NULL DEFAULT , `Password` char(64) NOT NULL DEFAULT , `Port` int(4) NOT NULL DEFAULT 0, `Socket` char(64) NOT NULL DEFAULT , `Wrapper` 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; [root@Mysql ~]# 备份MYSQL数据库结构: [root@Mysql ~]# /usr/local/mysql/bin/mysqldump -uroot -padmin123 -d mysql/backup/mysql-structure-$(date +%F).sql [root@Mysql ~]# egrep -v ^$|^--|* /backup/mysql-structure-2014-06-05.sql DROP TABLE IF EXISTS `columns_priv`; CREATE TABLE `columns_priv` ( `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT , `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT , ############################省略############################ PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=Column privileges; DROP TABLE IF EXISTS `db`; CREATE TABLE `db` ( `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT , `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT , `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT , ############################省略############################ `Event_priv` enum(N,Y) CHARACTER SET utf8 NOT NULL DEFAULT N, `Trigger_priv` enum(N,Y) CHARACTER SET utf8 NOT NULL DEFAULT N, PRIMARY KEY (`Host`,`Db`,`User`), KEY `User` (`User`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=Database privileges; DROP