mercredi 4 mars 2015

Replication broken after copying .frm .myd .myi files


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