After putting ibdata1 file in data folder, service does not start
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
Subject
Views
Written By
Posted
After putting ibdata1 file in data folder, service does not start
720
December 11, 2021 02:38AM
343
December 11, 2021 03:05AM
488
December 11, 2021 03:39AM
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.