HyperVm Backup(restore) help required

Hello
recently I rebuilt my vps so I take a hyperVm backup from hyperVm
which is in this format back.tgz

Now after rebuilt when I tried to restore the backup its not restoring
I also contacted lxlabs but not got the solution

I have downloaded this backup and extract it using winrar
I get my websites files from this extracted backup

But dont know where is the databases located in this backup
there are several dir in this backup

I need to manually restore the database

Does anyone know where these database files located in backup?

Please help!

 

dear just download the directories using your ftp and back up your database using mysql dumper restore the directories using ftp then restore database using mysqldumper

 

how did you back up your database?

and tell me you were running any CMS?

 

If you downloaded the full backup then the MySQL backup should be placed inside the MySQL directory. It should be located outside the public_html folder.

 

there is no public_html folder
this is not Cpanel/whm
this is hyperVM

 

That backup will have archives of mysql db's named after the domain alias. for eg you have alias named guttu then there will be tar or tgz archive named like guttu-mysqldb-any-xxxxxxxxx.tar or .tgz. extract that archive and you'll have a .dump file. rename it to .sql and import using bigdump or phpmyadmin.

 

no there is no such file

 

Can you tell which files you get after extracting the backup file back.tgz? Plz try downloading and extracting on your PC first.

 

I cant dl on my PC
it is extracted on the server and It has so many folders in there
bin
root
exec
home

etc...

 

check the folder "/var/lib/mysql". There will be subfolder with the dbnames. copy them to your current hosts "/var/lib/mysql". Login to phpmyadmin and assign an user for the privileges.

 

Yes I have found them
Thanks for your help
I hope I can recover this

 

Oh no the one I saw var/lib folder is my current folders
there is no lib folder in "var" of backup
it contains the following folders

 

try this folder

or search the back folder for "mysql" .you'll get the folder.

 

there is also nothing in /us/local/mysql
I also tried to search for mysql but in vain

 

search for *.dump files in the whole backup.

 

no cant find
Can u please tell me how to extract that .tgz hypervm backup file in the server
I mean through ssh or any way through hypervm
I want to extract that backup again or any old backup

 

thats the command to extract the archive

 

if my backup is in dir home what command to use?
Is it

?

 

Missing slash

It's better to change the dir to the dir where the archive is located. then simply execute

It'll extract in that folder.

 

Oh yes I extracted the backup myself and got the database in var/lib/mysql
Thanks for your support
My hosting provider was unable to get the database because they are expert in Cpanel and also that vps is self managed

But because of your help I got my corrupted database back now I am very good!
Thanks again!