Good backup/restore MySQL: Script to backup and restore databases

I need a reliable and good script to backup and restore databases.

by Alessandro Quintiliani package author 75 - 6 years ago (2017-01-29) Comment

Hello Norm,

I recently created a package Multi MySQLDump which can backup one ore more MySQL databases to SQL files, each SQL file for a database table to backup.

All the tables are backupped by launching parallel requests using AJAX calls. When the dump are completed, you can download either a zip or tgz archive for each database (it contains all the SQL backup tables) or, for each table, their SQL file, uncompressed or compressed in both zip or gzip format.

You can launch the main script of this package on demand or periodically by schedulation; on a new launch, a table is backupped only if something in their structure/data have changed respect of the previous backup (which can make the whole backup process a bit faster), but you can choose to backup one or more tables at each run, or exclude one or more tables.

I am at your disposal for any doubt or question. Best regards

by Gerry Danen package author 50 - 8 years ago (2015-03-10) Comment

This one would do the trick. 100% php, mysqli (not the old mysql interface).

by Ivan Melgrati package author 50 - 8 years ago (2015-03-10) Comment

Hi!, I created these PHP classes some time ago and I'm using them in some sites. They might be useful. They're 100% written in PHP.