Where is MySQL dump in directories extracted from backup

6 posts / 0 new
Last post
#1 Mon, 07/04/2011 - 22:24
yngens

Where is MySQL dump in directories extracted from backup

I have successfully created excremental scheduled backup via Virtualmin for my website, using strftime: /backup/mysite-com-%d-%m-%Y It creates a single tar.gz and separate info files and reports as follows:

Backup is complete. Final size was 30.57 MB. Total backup time was 00 minutes, 16 seconds.

Sent by Virtualmin at: https://host.mysite.com:10000

Creating backup for virtual server mysite.com ..


   Copying virtual server configuration ..
   .. done

   Backing up Cron jobs ..
   .. none defined.

   Copying records in DNS domain ..
   .. done

   Saving mail aliases ..
   .. done

   Saving mail and FTP users ..
   .. done

   Backing up mail and FTP user Cron jobs ..
   .. none to backup

   Copying Apache virtual host configuration ..
   .. done

   Copying Apache log files ..
   .. done

   Copying Webalizer configuration files ..
   .. done

   Copying Logrotate configuration ..
   .. done

   Dumping MySQL database mysite ..
   .. done

   Creating incremental TAR file of home directory ..
   .. done

As report shows it also dumps mysql database for my site, however when I extract archive file I get usual directories like: cgi-bin, fcgi-bin,  logs,        tmp,  etc, homes,   public_html,  www and no directory with mysql dump. I looked everywhere in extracted directories and could not find mysql dump. Where on earth Virtualmin's backup puts mysql dumps?

Mon, 07/04/2011 - 22:40
andreychek

Howdy,

The .sql file containing your MySQL dump is in a hidden directory named ".backups".

-Eric

Tue, 07/05/2011 - 01:41
yngens

That was far from being obvious. Thanks a lot, Andreychek!

Wed, 04/04/2012 - 08:47
yngens

Hitting the old problem again. I could easily find .sql file in .backup folder of extraction from partial backup. However today I tried extracting full backup file and it only gives:

l .backup
-rw-r--r-- 1 root     root     195 2012-04-01 22:55 mysite.com_logrotate
-rw-r--r-- 1 root     root       0 2012-04-01 22:55 mysite.com_mail
-rw-r--r-- 1 root     root       0 2012-04-01 22:55 mysite.com_mail_aliases
-rw-r--r-- 1 root     root       1 2012-04-01 22:55 mysite.com_mail_bcc
-rw-r--r-- 1 root     root       2 2012-04-01 22:55 mysite.com_mail_cron
-rw-r--r-- 1 root     root       0 2012-04-01 22:55 mysite.com_mail_users
-rwx------ 1 root     root    1489 2012-04-01 22:55 mysite.com_virtualmin
-rw-r--r-- 1 root     root    4658 2012-04-01 22:00 mysite.com_virtualmin_bw
-rw-r--r-- 1 root     root     264 2011-12-26 19:08 mysite.com_virtualmin_plan
-rw-r--r-- 1 root     root       0 2012-04-01 22:55 mysite.com_virtualmin_scripts
-rw-r--r-- 1 root     root    4608 2012-01-15 00:55 mysite.com_virtualmin_template
-rw-r--r-- 1 root     root    1292 2012-04-01 22:55 mysite.com_web
-rw-rw---- 1 username   48 1092378 2012-04-01 22:55 mysite.com_web_alog
-rw-rw---- 1 username   48    1454 2012-04-01 20:50 mysite.com_web_elog

no .sql file. Where it is gone now?

Wed, 04/04/2012 - 08:45
andreychek

Yeah, it doesn't look like that particular backup contains a database dump.

If you look in Virtualmin for that particular Virtual Server, and click Edit Databases, do you see any databases associated with it?

Also, if you go into Backup and Restore -> Backup Logs, does it show the backups as being successful?

-Eric

Wed, 04/04/2012 - 08:48
yngens

Thanks Eric,

I just dumped manually. And you are right - the website was not associated with a database.