MySQL Forums
Forum List  »  Data Recovery

ibdata file deleted - how to recover databases
Posted by: MOnchecourt lionel
Date: May 10, 2020 01:15PM

ibdata and ib_logfile1 & ib_logfile2 were deleted.
I managed to get mysql restarted by running the init but I can't access to the Databases.
the engine is seeing each DB, I can do a 'show table", but trying to access any , I get

"SQL show index from `admin` failed : Table 'asterisk.admin' doesn't exist in engine"

for example for my asterisk table.
I found many post on Internet, but 1st I'm not sure of the following statement :
does all my data are lost ? ( I still have all the files under /var/lib/mysql ...)

if they are not, what is the proper procedure to get back everything ? ( already tried several solutions I found on the net, but none is working ...)

Thanks in advance

Options: ReplyQuote

Written By
ibdata file deleted - how to recover databases
May 10, 2020 01:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.