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:
awstats
cgi-bin
etc
homes
logs
Maildir
public_html
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 
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,
-Eric
hi,
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?
-Eric
my log file is empty … I cannot monitor/check if i have some problems or not.
up
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.
Thanks