Whatever the reasons, rather than relying on plugins, a better alternative is to use a cron job in your server and schedule it to backup your database everyday. Note: The following instruction can be used to backup any database. The only requirement is that you are using a Linux server to host your files. Here is how you do it:

  1. Login to your web host control panel. If you are using cPanel, look for a Cron Job icon.

  2. You can set the time and frequency to backup the database. Under the command field, copy and paste the following command:

Replace dbusername with the database user Replace dbpassword with the database user password Replace dbname with the database that you are backing up Replace the path-to-store-the-backup-file to the file path in your server where you want to save the backup

Note: In some server, you might need to put a pair of single quote around the dbpassword for it to work. For example:

Email yourself the database

Storing the database on your server could take up plenty of storage space. One way you can do is to email the backup file to yourself.

  1. Download this php script.
  2. Extract the zip file and open the backup.php with a text editor.
  3. Change the database detail:
  4. Save the file. Upload the whole folder to your server. Note: The folder includes a .htaccess file to prevent any access from the browser. If you want to access from the browser, remove the .htaccess file.
  5. In the cron job section of the cPanel, enter the following command: That’s it.