Login   Register  
PHP Classes
elePHPant
Icontem

Database Copier

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author  
Picture of waqas khan kakar
Name: waqas khan kakar <e-mail contact>
Packages: 1 Browse all classes by waqas khan kakar Browse all classes by
Country: Pakistan Pakistan - PHP jobs in Pakistan
Age: 28
All time rank: 198726 in Pakistan Pakistan
Week rank: 1063 Up20 in Pakistan Pakistan Up
Innovation award
Innovation award
Nominee: 1x

Winner: 1x


  Detailed description   Download .zip .tar.gz  
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.

  Classes of waqas khan kakar  >  Database Copier  >  Download .zip .tar.gz  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Database Copier
Base name: copy-class
Description: Copy tables between MySQL databases
Version: 1.0
PHP version: 3
Licenses: GNU Free Documentation License (FDL)
GNU General Public License (GPL)
All time users: 1016 users
All time rank: 3154
Week users: 2 users
Week rank: 1329 Up
 
  Groups   Rate classes User ratings   Applications   Related links   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Systems administration System configuration and management View top rated classes


  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

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (62.5%)
Sufficient (62.5%)
-
Sufficient (68.8%)
-
-
Not sure (44.4%)
1870
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related links  
Link Description
www.virtualtech.asia example code with class description

  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

Download all files: copy-class.tar.gz copy-class.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.