samedi 31 janvier 2015

mysqlbinlog recovery table wise


I am going to restore my MySQL database table using log files. My database name is "decsys" .


I have already created sql using log files


C:\wamp\bin\mysql\mysql5.5.8\bin>mysqlbinlog -d decsys C:\wamp\bin\mysql\mysql5.5.8\data\mysql-bin.0000xx > sql1.sql (file size 8GB)


I want recover not whole database. only single table. (table name :cm).


please tell me how can i do this. thank you very much





Aucun commentaire:

Enregistrer un commentaire