PHP Classes
elePHPant
Icontem

PHP Database Synchronize Tables: Synchronize tables between two database using PDO

Recommend this page to a friend!
     
  Info   View files Example   View files View files (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2014-11-18 (2 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 220 This week: 1All time: 7,768 This week: 686Up
Version License PHP version Categories
phpdbsync 1.0MIT/X Consortium ...5PHP 5, Databases, Systems administration
Description Author

This class can synchronize tables between two database using PDO.

It can connect to a origin database and query the records of a given database table.

Then the class connects to a destination database and inserts the table records retrieved from the origin database table

Optionally the class can take a backup of the database tables to a file in a backup directory. It may also delete the destination table records before the synchronization is run.

Recommendations

What is the best PHP sqlite synchronize with mysql class?
Synchronize a local sqlite with a MySQL server

Database synchronization
Synchronization of databases
  Performance   Level  
Name: Ettore Moretti <contact>
Classes: 11 packages by
Country: Italy Italy

Level 4 StarStarStarStar

 Innovation award
Innovation award
Nominee: 3x

Details

PhpDatabaseSync

This class allows you to execute queries synchronized on various database (also of different types) and\or synchronize entire tables on different databases. You'll also get a chance to create backups before every launch.

See the file HowInvoke.php for more information

  Files folder image Files  
File Role Description
Files folder imagecore (2 files)
Files folder imageDb (1 directory)
Files folder imagedbBackup (1 file)
Accessible without login Plain text file example.php Example Example script
Accessible without login Plain text file HowInvokeIt.php Example Example script
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Data Documentation

  Files folder image Files  /  core  
File Role Description
  Plain text file DBSync.class.php Class Class source
  Plain text file DBSync.config.php Class Class source

  Files folder image Files  /  Db  
File Role Description
Files folder imagelite (1 file)

  Files folder image Files  /  Db  /  lite  
File Role Description
  Accessible without login Plain text file README.txt Doc. Documentation

  Files folder image Files  /  dbBackup  
File Role Description
  Accessible without login Plain text file README.txt Data Documentation

Downloadphpdbsync-2014-11-18.zip 10KB
Downloadphpdbsync-2014-11-18.tar.gz 7KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:220
This week:1
All time:7,768
This week:686Up

  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.