MySQL Forums
Forum List  »  Data Recovery

After putting ibdata1 file in data folder, service does not start
Posted by: Tahira Nasreen
Date: December 11, 2021 02:38AM

Server is crashed. But we have got MYSQL Data folder. Tn that folder there are following files:

ibdata1,
ib_logfile0,
ib_logfile1
database folder with .frm files and in some databases there are .frm,.MYI, .MYD files.

Anyone have an idea how to recover my databases back.
I am using MYSQL 5.5.
I have installed MYSQL 5.5 on new machine,

I copied the data folder. and renamed data_old.
then I just Copy databases folders from the crashed server mysql/data folder and put it in this data folder.
then i start the mysql service.
in localhost/phpmyadmin, i can see all databses with table names.

ISSUe: when i click any table, it show me an error
"table does not exist in engine"
then i Stop the service

After that i put ibdata1 file into this mysql/data folder. existing was replaced with this one.
then i tried to start service, it was not running.
Do you people have any idea after putting ibdata1 file from one machine mysql/data folder to another machine mysql/data folder. Service does not start . how to start mysql service???

Thanks in Advance

Options: ReplyQuote


Subject
Views
Written By
Posted
After putting ibdata1 file in data folder, service does not start
283
December 11, 2021 02:38AM


Sorry, only registered users may post in this forum.

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.