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?
Howdy,
The .sql file containing your MySQL dump is in a hidden directory named ".backups".
-Eric
That was far from being obvious. Thanks a lot, Andreychek!
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?
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
Thanks Eric,
I just dumped manually. And you are right - the website was not associated with a database.