Tweeted twitter.com/StackDBAs/status/1170985293605998592
3 Added backup tag since mysqldump performs backups
| link
2 edited body; edited tags
source | link

Because mysqldump takes forever, we decided to just move around the files. Because the 2 databases are on the same server, a cp will be fast.

The problem is, from research, MyISAM is okay with being moved entirely, but InnoDB is not. And 

I read about this: http://www.mysqlperformanceblog.com/2009/07/31/copying-innodb-tables-between-servers/

The final question is, is there a way to move the entire database at once and make sure that both the InnoDB and MyISAM tables are good.

Any ideas? Thank a lot!

Because mysqldump takes forever, we decided to just move around the files. Because the 2 databases are on the same server, a cp will be fast.

The problem is, from research, MyISAM is okay with being moved entirely, but InnoDB is not. And I read about this: http://www.mysqlperformanceblog.com/2009/07/31/copying-innodb-tables-between-servers/

The final question is, is there a way to move the entire database at once and make sure that both the InnoDB and MyISAM tables are good.

Any ideas? Thank a lot!

Because mysqldump takes forever, we decided to just move around the files. Because the 2 databases are on the same server, a cp will be fast.

The problem is, from research, MyISAM is okay with being moved entirely, but InnoDB is not.  

I read about this: http://www.mysqlperformanceblog.com/2009/07/31/copying-innodb-tables-between-servers/

The final question is, is there a way to move the entire database at once and make sure that both the InnoDB and MyISAM tables are good.

Any ideas? Thank a lot!

1
source | link

How to copy a MySQL database which is a mixture of InnoDB and MyISAM to the same server?

Because mysqldump takes forever, we decided to just move around the files. Because the 2 databases are on the same server, a cp will be fast.

The problem is, from research, MyISAM is okay with being moved entirely, but InnoDB is not. And I read about this: http://www.mysqlperformanceblog.com/2009/07/31/copying-innodb-tables-between-servers/

The final question is, is there a way to move the entire database at once and make sure that both the InnoDB and MyISAM tables are good.

Any ideas? Thank a lot!