How to backup phpMyAdmin automatically

If you host your website on a shared hosting then probably phpMyAdmin is the only way to access your MySql database. To this day, the best way to protect your data is to create regular backups, but how to automate this process with phpMyAdmin?

Well, fortunately, MySqlBackupFtp allows to backup your database connecting to it not only directly via TCP/IP, but also via phpMyAdmin’s web interface. This makes it working for almost every website even with the cheapest shared hosting.

So, how to create regular backups via phpMyAdmin?

PhpMyAdmin is one of the most popular applications for MySQL databases management which allow you to create, alter, delete, drop, export, and import MySQL database tables. Also, you can run MySQL queries, optimize, repair and check tables, change collation and execute other database management commands. And all this is absolutely free.

How to backup MySQL database using phpMyAdmin

Using phpMyAdmin you can create a database backup in a few simple clicks, it’s really easy. Follow this simple steps to backup your database:

1. Choose the database to be backed up from the list in the left pane
2. Click “Export” in the top navigation bar 
3. Select the “Quick” export method and click “Go”
MySQL phpMyAdmin backup
4. The database will be downloaded to the local machine’s default downloads location

That’s all. You have just backed up the database. But there are no particular settings in phpMyAdmin to backup your databases automatically and on a regular basis. Here is where MySqlBackupFtp shows up.

How to backup via phpMyAdmin using MySqlBackupFTP

With the help of MySqlBackupFTP, you can create a task that will make backups according to the schedule and send them to the selected storage. Here is what you have to do:

Download and install MySqlBackupFTP. Then, connect it to your MySQL Server using phpMyAdmin method:

MySQLBackupFTP Connect to MySql ServerYou need to enter your ordinally username and password you usually use to access phpMyAdmin. Click to “Test MySql Connection” button to test that everything works fine.

After you connected to MySQL Server, select all database that you need to backup from the list in the left pane

MySqlBackupFTP databases

Then, by clicking “Add backup destination” link select one or more places where your MySQL Server database backups will be sent for storing

MySqlBackupFTP backup destination

To create regular backups, click “Schedule this job” and “Advanced Backup Schedule” to set up backup schedule

MySqlBackupFTP schedule backup

That’s it, the backup job is ready. All you need is to save it by clicking “Save” button and, optionally, run it right away by pressing the “Run Now” button

MySqlBackupFTP Save

Test your backups periodically

One of the important points in the backup strategy is to check or test your backups. If you have a backup that contains all recent database changes it doesn’t mean that your data is 100%  safe. From time to time, you should practice restoring your database on another (test) server. Such practice is useful because if a failure occurs you will be sure that you have a reliable database backup and will be able to restore it in a short period of time.

Leave a Reply

Your email address will not be published.