Restore a database from a full plesk backup

[SalvadorS]

Hello,

I have a full plesk backup (3GB) and I need to restore just the tables of a database.

The backup is in .tar format. I listed the content of the backup, tar tvf backup_1403090050.tar, then find the file I want:

resellers/xxx/clients/xxx/domains/xxx/databases/database_1/backup_database_1_1403090050.tgz

So I extracted only this file:

tar xvf backup_1403090050.tar resellers/xxx/clients/xxx/domains/xxx/databases/database_1/backup_database_1_1403090050.tgz

Then I have one file:

backup_database_1_1403090050.tgz

But, here comes the problem, if I extract this file I have a file without extension:

backup_database_1_1403090050 (4MB)

I found this KB article http://kb.parallels.com/en/1757 and follow the steps, install mpack:

zcat backup_database_1_1403090050.tgz > backup_database_1_1403090050

Then cat backup_database_1_1403090050 | unpack

And I have this error:

munpack: reading from standard input
Did not find anything to unpack from standard input

file backup_database_1_1403090050
backup_st_beta_1_1403090050: POSIX tar archive (GNU)

And I don´t know what to do...

How I can uncompress the tables of the database from a plesk full backup?

Thanks in advance

 

[IgorG]

BTW, one of new features of upcoming Plesk 12:

Improved data restoration. Now users can restore individual reseller accounts, customer accounts, subscriptions, domains, DNS zones, mailboxes, mailing lists, databases, files and directories of a site, and SSL certificates.

http://download1.parallels.com/Plesk/PP12/parallels-plesk-12.0-for-linux-change-log.html

 

[SalvadorS]

BTW, one of new features of upcoming Plesk 12

Great! But in Plesk 11, how can I do that? How can I Restore a backup? It is not possible?

 

[IgorG]

file backup_database_1_1403090050
backup_st_beta_1_1403090050: POSIX tar archive (GNU)

Have you tried untar this file?

 

[SalvadorS]

Yes, but it does not work

root@xxx:/var/www/st# tar xvf backup_st_beta_1_1403090050
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Exiting with failure status due to previous errors

 

[IgorG]

No, I meant this file:

Then I have one file:

backup_database_1_1403090050.tgz

But, here comes the problem, if I extract this file I have a file without extension:

backup_database_1_1403090050 (4MB)

Have you checked it with file command? Is it POSIX tar archive (GNU)

 

[SalvadorS]

Yes, is the same file but I mistake the names.

I have backup_database_1403090050.tgz, If i uncompress this file I have another one: backup_database_1403090050 and if I try to untar this:

root@xxx:/var/www/st# tar xvf backup_database_1403090050
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Exiting with failure status due to previous errors

 

[IgorG]

Have you tried to open this file just with less command?

 

[SalvadorS]

If I type:

less backup_st_beta_1_1403090050

I see this:

-- MySQL dump 10.13 Distrib 5.1.66, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: xxx
-- ------------------------------------------------------
-- Server version 5.1.66-0+squeeze1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

(...) and many more... I´m going to use HeidiSQL to import it!

Thanks IgorG

 

[IgorG]

It is mysql dump file

http://www.howtoforge.com/faq/6_4_en.html

 

[SalvadorS]

Great! Thanks a lot for your help