Where is MySQL dump in directories extracted from backup

Virtualmin
1

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?

2

Howdy,

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

-Eric

3

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

4

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

5

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?

6

Thanks Eric,

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