3.1.2.2. Example Execution

shell> mysqldbcopy --source=root:root@localhost \
          --destination=root:root@localhost world_innodb:world_innodb_clone
# Source on localhost: ... connected.
# Destination on localhost: ... connected.
# Copying database world_innodb renamed as world_innodb_clone
# Copying TABLE world_innodb.City
# Copying TABLE world_innodb.Country
# Copying TABLE world_innodb.CountryLanguage
# Copying data for TABLE world_innodb.City
# Copying data for TABLE world_innodb.Country
# Copying data for TABLE world_innodb.CountryLanguage
#...done.

shell> mysql -uroot -proot -e "SHOW DATABASES"
+--------------------+
| Database           |
+--------------------+
| information_schema |
| employees          |
| mysql              |
| world_innodb       |
| world_innodb_clone |
+--------------------+
        


User Comments
Sign Up Login You must be logged in to post a comment.