备份MYSQL数据表结构与数据库结构教程.doc
文本预览下载声明
备份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
显示全部