PHP Classes
elePHPant
Icontem

PHP MySQL Database Synchronize: Synchronize MySQL databases tables between servers

Recommend this page to a friend!
  Info   View files Example   View files View files (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2016-12-08 (5 months ago) RSS 2.0 feedStarStarStarStar 65%Total: 173 This week: 1All time: 8,155 This week: 640Up
Version License PHP version Categories
mysql-database-synch 1.0Freeware5PHP 5, Databases, Systems administration, W...
Description Author

This package can synchronize MySQL databases tables between servers.

One class can retrieve the list tables and records from the origin server MySQL database and send the data to another server script via HTTP.

On the destination server a script receives the request and recreates the origin tables in a MySQL database and inserts the retrieved records.

  Performance   Level  
Name: Bharat Parmar <contact>
Classes: 11 packages by
Country: India India
Age: 26
All time rank: 92653 in India India
Week rank: 33 Up8 in India India Up
Innovation award
Innovation award
Nominee: 3x

Details

mysql-database-synchronization-with-php

Synchronize MySQL Database from One Server to Another Server or from One Database to Another Database on the same server using Simple PHP Script.

The source code is available at github. You can either clone the repository or download a zip file of the latest release.

Requirement


1. cURL should be enabled

How To Use

1. copy & paste `server1` directory files on your first server.

2. set database details for the database which you want to synchronize to another database in 
	`includes/config.php` file.

3. copy & paste `server2` directory files on your second server. 

4. set Synchronization URL in `includes/config.php` which should have `server2` directory files. 

5. set database details for the database where you want to synchronize first database data.

6. execute `server1/example.php`

Example


`server1/example.php` (Send Data to server2/example.php)

To make it automatic synchronization on particular interval, you can run the 
server1/example.php as cronjob on specific time.

Output

Array
(
    [data] => Array
        (
            [bh_user_master] => Table Created. 8 Rows Inserted.
            [bh_user_message] => Table Created.
        )

    [status] => success
    [message] => Database synchronization initiated.
)


Array
(
    [data] => []
    [status] => fail
    [message] => No Table Found./Table Structure Not Found./
)

Limitation :

1. This is just for the Development mode only demo. When the script 
	synchronize the database, first it will drop the table on second 
	server and create new table and after that insert all data. 
	During the synchronization time, f the server stopped to respond, 
	the second server database will be truncated. 

2. Synchronization time, table structure and all rows will be 
	synchronization to avoid the collumn/data updation after 
	last synchronization.

Author

Bharat Parmar

Ahmedabad, India.

Mobile : +91 9687766553 Email : bharatparmar383@gmail.com

  Files folder image Files  
File Role Description
Files folder imageserver1 (1 file, 2 directories)
Files folder imageserver2 (1 file, 2 directories)
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  server1  
File Role Description
Files folder imageclass (1 file)
Files folder imageincludes (1 file)
  Accessible without login Plain text file example.php Example Example script

  Files folder image Files  /  server1  /  class  
File Role Description
  Plain text file server1.class.php Class Class source

  Files folder image Files  /  server1  /  includes  
File Role Description
  Accessible without login Plain text file config.php Aux. Auxiliary script

  Files folder image Files  /  server2  
File Role Description
Files folder imageclass (1 file)
Files folder imageincludes (1 file)
  Accessible without login Plain text file example.php Example Example script

  Files folder image Files  /  server2  /  class  
File Role Description
  Plain text file server2.class.php Class Class source

  Files folder image Files  /  server2  /  includes  
File Role Description
  Accessible without login Plain text file config.php Aux. Auxiliary script

 Version Control Unique User Downloads Download Rankings  
 100%
Total:173
This week:1
All time:8,155
This week:640Up
User Ratings User Comments (1)
 All time
Utility:83%StarStarStarStarStar
Consistency:75%StarStarStarStar
Documentation:83%StarStarStarStarStar
Examples:83%StarStarStarStarStar
Tests:-
Videos:-
Overall:65%StarStarStarStar
Rank:658
 
Very Good package.
5 months ago (Jack Thomas)
77%StarStarStarStar