Login   Register  
PHP Classes
elePHPant
Icontem

Database Copier : Copy tables between MySQL databases

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2010-03-09 (4 years ago) RSS 2.0 feedStarStarStar 44%Total: 1,071 All time: 3,207 This week: 1,503Up
Version Licenses PHP version Categories  
copy-class 1.0GNU Free Documentation ...3Databases, Systems administration
Description Author  

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: 29
All time rank: 205026 in Pakistan Pakistan
Week rank: 1723 Up33 in Pakistan Pakistan Down
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

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

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,071All time:3,207
 This week:0This week:1,503Up
User Ratings User Comments (1)  
 All time
Utility:62%StarStarStarStar
Consistency:62%StarStarStarStar
Documentation:-
Examples:68%StarStarStarStar
Tests:-
Videos:-
Overall:44%StarStarStar
Rank:1961