Unpack (NOT restore) a PSA Dump?

[Soulhuntre]

Hey all!

I have a Linux Plesk 7.5 system that did a backup with this command...

(assume $fname containes a filename)

/usr/local/psa/bin/psadump --nostop --nostop-domain --noblock -f - | gzip > /root/psa_backup/$fname

I want to extract the MySQL database for a single domain, without having to go through a messy restore process. Is that possible?

 

[phoenixisp]

http://download1.sw-soft.com/Plesk/Plesk7.5/Doc/plesk-7.5r-backup-restore-html/index.html

There is a section on selective restoring that may help.

 

[Soulhuntre]

Originally posted by phoenixisp
http://download1.sw-soft.com/Plesk/Plesk7.5/Doc/plesk-7.5r-backup-restore-html/index.html

There is a section on selective restoring that may help.

The problem is I need to retrieve the old MySQL database and merge it with the current one (there was some accidental deletion of records).

Selective restore is useless for this - even if I map the domain to a new name the MySQL DB will still want to come in with the old name and either fail or over-write the current one.

I really want to expand that archive onto disk and get the data myself.

 

[phoenixisp]

I don't think you can do what you are trying to do. Maybe you could setup another server, restore the dump file and then extract your database.

 

[Soulhuntre]

Originally posted by phoenixisp
I don't think you can do what you are trying to do. Maybe you could setup another server, restore the dump file and then extract your database.

Yeah, I have a VPC runnign and am putting in Ubuntu now for that. But its a seriously silly thing not to be able to do.

 

[thewolf]

Originally posted by Soulhuntre
Yeah, I have a VPC runnign and am putting in Ubuntu now for that. But its a seriously silly thing not to be able to do.

I feel your pain. Anyone from SWsoft listening?

Thanks.

 

[phoenixisp]

Sorry guy, sw-soft is not listening. This being strictly a users forum they do not monitor it. Send them an email.

 

[AlleyKat]

My method is MIME-decode the file in TotalCommander, then finding the right resulting .bin file (you get a bunch and a text file), rename it to .gz, extract the file within - thats the sqldump of the database. A little edit in the file with any plaintext editor and it's fixed and ready to restore...