mysql管理工_MySQL管理工具MySQL Utilities — mysqldbcopy改变存储引擎(12)

# mysqldbcopy --source=instance_3306 --destination=instance_3308 --new-storage-engine=myisam ttlsa_com:ttlsa_com_copy

# Source on localhost: ... connected.

# Destination on localhost: ... connected.

# Copying database ttlsa_com renamed as ttlsa_com_copy

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_categories`.

# Copying TABLE ttlsa_com.bbs_categories

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_comments`.

# Copying TABLE ttlsa_com.bbs_comments

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_favorites`.

# Copying TABLE ttlsa_com.bbs_favorites

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_forums`.

# Copying TABLE ttlsa_com.bbs_forums

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_links`.

# Copying TABLE ttlsa_com.bbs_links

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_notifications`.

# Copying TABLE ttlsa_com.bbs_notifications

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_page`.

# Copying TABLE ttlsa_com.bbs_page

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_settings`.

# Copying TABLE ttlsa_com.bbs_settings

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_tags`.

# Copying TABLE ttlsa_com.bbs_tags

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_tags_relation`.

# Copying TABLE ttlsa_com.bbs_tags_relation

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_users`.

# Copying TABLE ttlsa_com.bbs_users

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_user_follow`.

# Copying TABLE ttlsa_com.bbs_user_follow

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`bbs_user_groups`.

# Copying TABLE ttlsa_com.bbs_user_groups

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`data`.

# Copying TABLE ttlsa_com.data

# Replacing ENGINE=InnoDB with ENGINE=myisam for table `ttlsa_com_copy`.`t_data`.

# Copying TABLE ttlsa_com.t_data

# Copying data for TABLE ttlsa_com.bbs_categories

# Copying data for TABLE ttlsa_com.bbs_comments

# Copying data for TABLE ttlsa_com.bbs_favorites

# Copying data for TABLE ttlsa_com.bbs_forums

# Copying data for TABLE ttlsa_com.bbs_links

# Copying data for TABLE ttlsa_com.bbs_notifications

# Copying data for TABLE ttlsa_com.bbs_page

# Copying data for TABLE ttlsa_com.bbs_settings

# Copying data for TABLE ttlsa_com.bbs_tags

# Copying data for TABLE ttlsa_com.bbs_tags_relation

# Copying data for TABLE ttlsa_com.bbs_users

# Copying data for TABLE ttlsa_com.bbs_user_follow

# Copying data for TABLE ttlsa_com.bbs_user_groups

# Copying data for TABLE ttlsa_com.data

# Copying data for TABLE ttlsa_com.t_data

#...done.