Re: i have copied the ibdata file without stopped the mysql server, and can't restore now
Posted by:
Rick James
Date: February 08, 2015 01:15PM
You say "copied"; perhaps you mean "moved"?
Copying a file should not have any impact on the copy left behind, so I don't see why anything would go wrong.
Moving those files is very bad...
The abcd.ibd file defines the existence of table `abcd` in the database indicated by the name of the directory it is in.
ibdata1 contains everything else about that table and all other tables. It is constantly being updated. Moving it while mysqld is running would be disastrous.
To recover (NOT guaranteed to work)
1. Stop mysqld (kill it if necessary).
2. Move the files back in place.
3. Start
4. Look at mysqld.err to see if it started up correctly, or to see how bad the damage is. If bad, follow the instructions there. And hope.
I hope you have a backup.
Subject
Views
Written By
Posted
1733
February 07, 2015 07:51AM
Re: i have copied the ibdata file without stopped the mysql server, and can't restore now
1747
February 08, 2015 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.