PHP Classes

Database Copier : Copy tables between MySQL databases

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
StarStarStar 42%Total: 1,142 All time: 3,304 This week: 68Up
Version Licenses PHP version Categories
copy-class 1.0GNU Free Document...3Databases, Systems administration
Description 

Author

waqas khan kakar

This class can be used to copy tables between MySQL databases.

It can access a MySQL server, list its tables, query the table record data, connect to another MySQL server and recreate the database tables with data copied from the first database.

The class can drop the destination tables with the same names if they already exist.

Innovation Award
PHP Programming Innovation award winner
April 2010
Winner

Prize: One license of ScriptCase Enterprise edition		 Sometimes it is necessary to migrate MySQL databases between two servers.

Often it is employed the solution of dumping the origin database table to SQL file that is executed in the destination server. However this solution is usually very slow.

This class implements a faster solution that consists in querying the origin database and inserting the retrieved data in the destination database directly.

Manuel Lemos
Picture of waqas khan kakar
Name: waqas khan kakar <contact>
Classes: 1 package by
Country: Pakistan Pakistan
Age: 40
All time rank: 218727 in Pakistan Pakistan
Week rank: 195 Up3 in Pakistan Pakistan Up
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

  Files folder image Files (2)  
File Role Description
Accessible without login Plain text file dumper_exp1.php Example example work
Plain text file copyclass.php Class database copier

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
Downloadcopy-class-2010-03-09.zip 1KB
Downloadcopy-class-2010-03-09.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,142
This week:0
All time:3,304
This week:68Up
User Ratings User Comments (1)
 All time
Utility:60%StarStarStarStar
Consistency:60%StarStarStarStar
Documentation:-
Examples:65%StarStarStarStar
Tests:-
Videos:-
Overall:42%StarStarStar
Rank:3644
  

  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.


  Related pages  
example code with class description