PHP MySQL Sync toolSync one or more MySQL databases with 1 conveniant class |
DB Sync 1.2 offers fast and easy syncrhonisation between your online database.
|
DB Sync 1.2
Buy it!Through the secure paypal system, you can but this class for just 30€ (VAT incl.) As soon as we receive confirmation of paypal, we will send you the class via e-mail. |
Who made it?
DB Sync is a product of Thisconnect. Thisconnect develops custom web-applications. How it works?
As a PHP-developer, the best way to see how it works, is showing you. See for yourself how easy it is. Important: The class syncs structures, not data. Synchronisation of data is much more complex, since every situation is different. require_once('dbsyncclas.php'); // init $dbsync=new MySqlDBSync(); // add sources $dbsync->AddSource('localhost', 'syncdbsource', 'root', '', ''); // add target $dbsync->AddTarget('localhost', 'syncdbtarget1', 'root', '', ''); $dbsync->AddTarget('localhost', 'syncdbtarget2', 'root', '', ''); // Return Array of scripts $dbsync->ReturnEachSql(); // Return Array of scripts $dbsync->ExecuteSql(); The resultA possible resulting array Array ( [0] => Array ( [DBName] => Array ( [0] => synctarget1 ) [scripts] => Array ( [0] => ALTER TABLE `table1` ADD COLUMN `field2` varchar(255) ; [1] => ALTER TABLE `table1` ADD COLUMN `field1` varchar(100) ; [2] => ALTER TABLE `table1` DROP COLUMN `veld1`; [3] => CREATE TABLE `table2`( `id` bigint(11) NOT NULL, `field1` varchar(255), UNIQUE KEY `veld3` (`field1`) ) ENGINE=InnoDB DEFAULT COLLATE=utf8_general_ci; ) ) ) |
© 2009 - A product of Thisconnect.be |