Accidentally deleted mysql ibdata1 and ib_logfile1

[kuokoad]

Please HELP ME:

I for some reason deleted the ibdata1, ib_logfile1, ib_logfile0 mysql data folder, then i realized all my databases are gone. I have also cleared my recycle bin.

Is a there a way I can recover or restore the databases?

Thank you.

[leokhoa]

@kuokoad : If the data is matter to you, you can try some file recovery tools on Windows.
Otherwise, you can try:

1. Rename your data dir to data.bak
2. Start MySQL -> MySQL will start with fresh data
3. Stop MySQL
4. Copy all data in data.bak to data
5. Start MySQL

[kuokoad]

I did that but in phpmyadmin when you click on a table (wordpress table) it tells you table doesn't exist.

[kuokoad]

@leokhoa got it working. with some googlings. Was able to recover all my database

1. with the post here

2. and because this link https://recovery.twindb.com/ is not wrking, i went with this post

[leokhoa]

@kuokoad : I'm glad you recovered your data!
Thank you for sharing your solution. It will be very helpful.