Help - Search - Members - Calendar
Full Version: Problems recovering a Plesk 7.5 MYSQL database
The Planet Forums > Control Panels > Plesk
juanit0
Hi, I'm in the process of recovering the data from a 7.5 plesk install.

Right now I copied the old psa directory to the mysql directory of the new system, witch is the way I did when I last had to this.

I can see the tables but I can't access any data, MYSQL send me this message: #1016 - Can't open file: 'components.ibd' (errno: 1)

If I try to do a repair I got this message for every single table in the database:
Can't open file: 'backuptasks.ibd' (errno: 1)

ALway reffering to a .ibd file, witch doesn't exist, the psa database only contain .frm files.
huck
There are innodb files in /var/lib/mysql/ib* You will need those as well. Unless versions are identical between the new and old server, you may run into issues.

Usually we try to dump mysql and then reimport it. You can often chroot into a slaved drive startup mysql, make a dump and then re-import on the new drive.
juanit0
Thanks, finaly an answer somewhere! icon_razz.gif

Trying right away, brb!
juanit0
Getting better thanks to you!

I downloaded the file "ibdata1" from my old install and placed it on my local mysql server and I can now browse a part of the tables, I think all the tables I need to recreate my users accounts are there! I see the light at the end of the tunel, thanks to you!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.