extract database from dead plesk?

[Tormente]

Something went horribly wrong with plesk that I ended up replacing the drive and installing everything fresh, restoring the domains from backup.

Anyway, there was data on the old mysql database that happened sometime after my backup that we would really like to get back. But, any ideas on how to do so?

Currently I have the old drive mounted as /media/old/ so I can access it...

thanks for any help.

 

[EBHAUK]

Hi,

Not sure your filesystem will be the same, but here is something you can try:

The databases on my system are located at - /var/lib/mysql/some_databases

Copy all below the mysql folder to your current mysql filesystem and you may succeed in merging your database structures.

Obviously backup all current databases first and ensure compatible versions before copying files across.

Regards

Pete

 

[gromett]

Be very carefull doing this. Do not copy the psa or mysql databases across as these have information relating to your new configuration.

if you cd into the old mysql directory and tar the specific database using for example.

cd /media/old/var/lib/mysql/
tar cz dbname >dbname.tar.gz

Then
mv dbname.tar.gz /var/lib/mysql/
cd /var/lib/mysql
tar xvzf dbname.tar.gz

using tar will give you a backup for later use when you disconnect the old HD as well as moving it across.

Cheers
Karl

 

[Tormente]

thanks for the reply,

I'm mostly concerned for a single site so I'm not doing the entire server.

I tried backing up and copying the old database over but the site freaked out saying it was missing a file - don't recall off the top of my head and I can't reproduce it at the very moment, but I think it was something to do with a file called exp_throttle or something like that.