PHP Classes

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

Recommend this page to a friend!
  All requests RSS feed  >  Good backup/restore MySQL  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

Good backup/restore MySQL

Edit

Picture of Norm Huehlefeld by Norm Huehlefeld - 9 years ago (2015-03-10)

Script to backup and restore databases

This request is clear and relevant.
This request is not clear or is not relevant.

+8

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

Ask clarification

3 Recommendations

PHP Multi MySQLDump: Dump MySQL database tables for file download

This package can dump MySQL database tables for file download.

It can dump one or more tables of a MySQL databases to files using PDO. All tables are dumped by parallel asynchronous AJAX requests.

The package can dump all database tables or exclude some of the tables.

It can avoid making table backups of tables that did not change since last backup by determining a checksum values for each table contents and checking if it changed.
This recommendation solves the problem.
This recommendation does not solve the problem.

+1

Picture of Alessandro Quintiliani by Alessandro Quintiliani package author package author Reputation 120 - 8 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

  • 1 Comment

  • 3. Picture of Mufaz Reload by Mufaz Reload - 4 years ago (2020-03-07) in reply to comment 2 by Alessandro Quintiliani Reply

    yes

Danen MySQL Backup: Create database backup SQL statements using MySQLi

This class can create database backup SQL statements using MySQLi.

It can connect to a MySQL database table using the MySQLi extension and generates a file with SQL statements that can be used later to restore the table definition and record data of one or more database tables.

The class creates a backup file with a unique name and returns the backup file name.
This recommendation solves the problem.
This recommendation does not solve the problem.

+6

Picture of Gerry Danen by Gerry Danen package author package author Reputation 55 - 9 years ago (2015-03-10) Comment

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

  • 1 Comment

  • 1. Picture of Anshul gisma by Anshul gisma - 6 years ago (2018-10-08) Reply

    please guide to use it in my server project

IAM Backup: Performing a backup and restore of MySQL databases

IAM backup is package made of two classes. One performs the backup of the selected MySQL database, and the second restores the database. Both classes support gzip-compressed files for improved performance. When performing the backup, the user is prompted to download the backup file, straight from the browser. Alternatively, the backup can be stored on the local server at a predefined location. Restoring the database (or copying it to another server) is just as easy.
This recommendation solves the problem.
This recommendation does not solve the problem.

+6

Picture of Ivan Melgrati by Ivan Melgrati package author package author Reputation 55 - 9 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.

Recommend package
: 
: