juanit0
Sep 2 2006, 04:23 PM
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
Sep 2 2006, 08:23 PM
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
Sep 2 2006, 09:39 PM
Thanks, finaly an answer somewhere!
Trying right away, brb!
juanit0
Sep 2 2006, 09:45 PM
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.