PHP Classes

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

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 246 All time: 7,978 This week: 57Up
Version License PHP version Categories
copydb 1.0.1MIT/X Consortium ...5PHP 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
PHP Programming Innovation award winner
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
Picture of René Mansveld
  Performance   Level  
Name: René Mansveld is available for providing paid consulting. Contact René Mansveld .
Classes: 3 packages by
Country: Germany Germany
Age: 60
All time rank: 3531198 in Germany Germany
Week rank: 195 Up8 in Germany Germany Up

Level 2 StarStar

 Innovation award
Innovation award
Nominee: 1x

Winner: 1x

  Files folder image Files (1)  
File Role Description
Plain text file copydb.php Class Script

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadcopydb-2021-09-22.zip 4KB
Downloadcopydb-2021-09-22.tar.gz 4KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:246
This week:0
All time:7,978
This week:57Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.