Creating a backup of your database

Webmin can help you make backups of your MySQL databases. With just a few clicks, you can make a backup of any database. Webmin can also help you set up cron jobs to create backups automatically on a regular schedule.

Getting ready

Before starting, create a directory to store local backup files. You can keep these files in /backups in the root directory /root/backups, or in any location that you find convenient.

Tip

Backup files created by Webmin will be readable by all users of your system. This may be a security risk, since database backups often contain sensitive data such as hashed user passwords. You should remove all permissions on the backups directory for users outside of root's group. You can do that by issuing the following command:

$ sudo chmod o-rwx /backups

If your file system supports access control lists, you can additionally set the default mask for newly created files in this directory in such a way that they are not readable by users outside...