PHP MySQL Copy Database: Copy MySQL tables from one database to another

Recommend this page to a friend!

Download .zip

Info

View files (1)

Download .zip

Reputation

Support forum (2)

Blog (1)

Links

Ratings				Unique User Downloads		Download Rankings
Not yet rated by the users				Total: 241		All time: 8,014 This week: 80

Version		License		PHP version		Categories
`copydb` 1.0.1		MIT/X Consortium ...		5		PHP 5, Databases, Systems administration

Description

Author

Ren� Mansveld

This class can copy MySQL tables from one database to another.

It provides a Web page script and a class that extends the PHP MySQLi to connect to a given MySQL database server.

The script executes queries using the class to copy all table records from one database in one server to another in the same server or a different server.

It copies 100 table records at a time if those records are not damaged.

The origin and destination MySQL servers can run different versions of MySQL.

Notice that if the origin MySQL server crashes, you should restart the server before you use this class to copy the records.

If the process of reading from damaged tables takes longer, you should set the PHP execution time limit option to at least 2 minutes (120 seconds).

Innovation Award

September 2021
Winner

Prize: One official elePHPant Plush Mascott

Sometimes it may be necessary to recover a database that has some damage due to an accident.

One way to recover that database is to copy the records of the tables that you can still save to another database.

This class provides a solution to save the table records of a MySQL database to another database.

It can copy a small number of records at a time to save as many records as possible.

Manuel Lemos