I copied .frm .myd .myi files for MyISAM tables from old_prod server to new_prod.
Then I did a mysqlcheck on DB and repair tables whenever necessary. All is good for MyISAM tables in the new_prod.
What happen is I have a slave configured to replicate from the new_prod.
Error from slave,
mysql> show slave status\G; .... Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 1049
Last_SQL_Error: Error 'Unknown database 'ReportDB'' on query. Default database: >'ReportDB'. Query: 'create table table1 (name varchar(40))'.....
I do not wish to skip the slave error as I need these tables to be in the new slave. Any thoughts to remedy this please?
Aucun commentaire:
Enregistrer un commentaire