This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

MySQL backup location?

9 posts / 0 new

Topic locked

Last post

#1 Sat, 06/21/2008 - 08:05

jmunjr

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:

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!

#2 Sat, 06/21/2008 - 08:25

jmunjr

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

#3 Thu, 06/26/2008 - 06:12 (Reply to #2)

saoullabit

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 ?

#4 Thu, 06/26/2008 - 06:26 (Reply to #3)

andreychek

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

#5 Thu, 06/26/2008 - 09:57 (Reply to #4)

saoullabit

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 ?

#6 Thu, 06/26/2008 - 10:00 (Reply to #5)

andreychek

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

#7 Fri, 06/27/2008 - 00:59 (Reply to #6)

saoullabit

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

:cry:

#8 Sun, 06/29/2008 - 22:47 (Reply to #7)

saoullabit

up :)

#9 Wed, 11/18/2009 - 16:25

jmunjr

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

Topic locked