Using PHPMyAdmin in Conjunction with Automatic Backup Tools

PHPMyAdmin can be used as a part of MySQL automatic backup, despite the PHPMyAdmin utility has no tools for scheduling jobs. Instead of forcing PHPMyAdmin backup database automatically, please set this task to some automated backup software.

Handy Backup software allows creating backups of MySQL databases as easily as common files and folders. To learn about the MySQL Backup plug-in, please see MySQL Backup Software.

PHPMyAdmin can be used in conjunction with such an automatic backup software to manage, pack, resort or view MySQL databases, as well as some other data types supported by PHPMyAdmin utility, as the perfect manual controlling tool.

Download Handy Backup

Version 8, built on 4 March, 2019
104 MB


PHPMyAdmin Automatic Backup Implementations


There are some solutions for PHPMyAdmin scheduled backup:

phpMyAdmin Auto Backup

  • Doing this action manually, on a regular basis (perhaps via the automatic notification);
  • Using scripts with PHPMyAdmin and scheduling software, like cron to provide a simulacrum of automatic PHPMyAdmin backup;
  • Operating in a somewhat automatic manner via some CMS, like Drupal, Joomla or Wordpress CMS.


What I Can Apply for Auto Backup of MySQL Database Instead of PHPMyAdmin?


Auto MySQL Backup

This is a lot of MySQL backup software with automated functions. We recommend you to use Handy Backup, a pro-grade workstation backup and server backup software, allowing automated MySQL backup and restoration without a need of manual job (except some simple initial setup).


Features

  • Featured MySQL backup option, allowing automating MySQL backup;
  • Perfect scheduling of backup tasks with a period from minutes to months;
  • Saving MySQL backups in native format, allowing replicating and cloning data by backup;
  • Many control options, such as compressing, encrypting and differential MySQL data backup.


Possibilities

Handy Backup can save not only MySQL databases but also data from any applications running under MySQL, including websites and CMS content, as well as automatically backing up and restoring any other data you need to save. Any task job can be scheduled and fully automated.


Considerations of the Format

When Handy Backup saves any uncompressed and unencrypted data as backups, it preserves original file formats and data structure. For MySQL backups, it means possibilities of cloning and mirroring MySQL content by “restoring” these databases to other places.

User can also apply PHPMyAdmin auto backup opening and modifying functions, as PHPMyAdmin recognizes backup copies as a typical database, regardless of restoration or replication takes place or not.




Recommended Solution

Handy Backup Small Server

Version 8, built on 4 March, 2019. 104 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup Small Server

If you have a MySQL database that you need to administer, and searching for a MySQL backup tool, then you need the Small Server edition. Free 30-days trial version!

How to Use MySQL Auto Backup Software Instead of PHPMyAdmin

You can see the video instruction teaching how to use Handy Backup software for MySQL backup and recovery. It can be interesting that the PHPMyAdmin utility appears in this video for illustrating the structure and properties of the database saved:



This video is about backing up and restoring MySQL 5.516 with Windows version of Handy Backup 7.3.0. To add and modify test data in the database, and track the changes after recovery, the author of this video uses phpMyAdmin software 3.5.1.

Download Handy Backup

Version 8, built on 4 March, 2019
104 MB

See also:

0 comments

    Who uses our backup software?