Sunday, March 10, 2013

how to recover a table in mysql if error is like table not exists




In the separate database create a table of same name
del its frm and ibd file from datadir(1st only frm and later ibd)
replace it with the older frm and ibd from the older database
check for permissions and user

you will now see your data and table in mysql prompt

No comments: