MySQL backup location?

I mucked up part of my mysql database and need to restore just the database to an offline location.

I extracted the backup file but don’t seem to see any mysql files.

Below are the only folders visible when I extracted the database backup .gz file:


I have a scheduled backup running and the “Contents of server’s MySQL databases” was definitely checked when set up.

How to I extract the mysql dump file? Where is it located? Thanks!

ok never mind. i was looking at the extraction done from inside linux. not sure why it didn’t allshow. i downloaded the backup file and extracted on my windows box. all is good. thanks

Hi, for me it’s a problem now :slight_smile:
there is a .backup where the mysql databases seems to be dumped here

I take a look a the files and there is, for one of my hosted site, a missing database
the ‘root’ database of the site … where the client has his working web site.

How can I check if the dump is done fully or partially ?

So, you see some databases being backed up, but not this one in particular?

Do you see any errors mentioned in the logfile, /var/log/mysqld.log ?

Also, if you try to manually dump the database, does that work? You can use:

mysqldump -u USERNAME -p DATABASENAME > db-backup.sql

Have a good one,


Do you see any errors mentioned in the logfile, /var/log/mysqld.log ?

this file does not exist but :
-rw-r----- 1 mysql adm 0 2008-06-26 06:25 mysql.log

Also, if you try to manually dump the database, does that work?
yes i did :
mysqldump -u DOMAINE.FR -p DOMAINE.FR > db-DOMAINE.FR.sql

-rw-r–r-- 1 root root 23M 2008-06-26 20:50 db-DOAMINE.FR.sql

Strange isn’t it ?

Well, the exact name of the log can vary from system to system.

It’s good that you’re able to dump the DB manually – do you see anything in your mysql.log that would suggest trouble with it or other databases?

my log file is empty … I cannot monitor/check if i have some problems or not.


up :slight_smile:

I created this thread a long time ago and now once again I cannot find the mysql database in the backup file…

How would I extract it from the archive? Where is it located? A specific folder? I opened multiple archives both via Linux and on a Windows box using three different compression apps (Winzip, 7zip, and WinRAR) and I can’t find anything.

I am very confident the databases were included in the backup.

Please help.