mysql 如何复制数据库_MySQL管理工具MySQL Utilities — 如何复制数据库(7)

# mysqldbcopy --source=instance_3306 --destination=instance_3307 --drop-first --all -vvv

# Source on localhost: ... connected.

# Destination on localhost: ... connected.

# Including all databases.

# Copying database test

# Copying GRANTS from test

GRANT ALTER ON `test`.* TO ''@'%'

GRANT CREATE ON `test`.* TO ''@'%'

GRANT CREATE ROUTINE ON `test`.* TO ''@'%'

GRANT CREATE TEMPORARY TABLES ON `test`.* TO ''@'%'

GRANT CREATE VIEW ON `test`.* TO ''@'%'

GRANT DELETE ON `test`.* TO ''@'%'

GRANT DROP ON `test`.* TO ''@'%'

GRANT EVENT ON `test`.* TO ''@'%'

GRANT INDEX ON `test`.* TO ''@'%'

GRANT INSERT ON `test`.* TO ''@'%'

GRANT LOCK TABLES ON `test`.* TO ''@'%'

GRANT REFERENCES ON `test`.* TO ''@'%'

GRANT SELECT ON `test`.* TO ''@'%'

GRANT SHOW VIEW ON `test`.* TO ''@'%'

GRANT TRIGGER ON `test`.* TO ''@'%'

GRANT UPDATE ON `test`.* TO ''@'%'

# Copying database ttlsa_com

# Dropping new object TABLE ttlsa_com.`data`

# WARNING: Unable to drop `data` from destination database (object may not exist): DROP TABLE `ttlsa_com`.`data`

# Copying TABLE ttlsa_com.data

CREATE TABLE `data` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`value` char(30) NOT NULL DEFAULT '',

`count` int(11) DEFAULT NULL,

PRIMARY KEY (`value`),

KEY `id` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1

# Dropping new object TABLE ttlsa_com.`t_data`

# WARNING: Unable to drop `t_data` from destination database (object may not exist): DROP TABLE `ttlsa_com`.`t_data`

# Copying TABLE ttlsa_com.t_data

CREATE TABLE `t_data` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`value` char(30) NOT NULL DEFAULT '',

`count` int(11) DEFAULT NULL,

PRIMARY KEY (`value`),

KEY `id` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

# Copying database ttlsa_com_copy

# Dropping new object TABLE ttlsa_com_copy.`data`

# WARNING: Unable to drop `data` from destination database (object may not exist): DROP TABLE `ttlsa_com_copy`.`data`

# Copying TABLE ttlsa_com_copy.data

CREATE TABLE `data` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`value` char(30) NOT NULL DEFAULT '',

`count` int(11) DEFAULT NULL,

PRIMARY KEY (`value`),

KEY `id` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1

# Copying data for TABLE ttlsa_com.data

# Getting indexes for ttlsa_com.data

# Copying data for TABLE ttlsa_com.t_data

# Copying data for TABLE ttlsa_com_copy.data

# Getting indexes for ttlsa_com_copy.data

#...done.

Time: 1.62 sec