PHP Classes

2 problems

Recommend this page to a friend!

      Data Migrator and Merger  >  All threads  >  2 problems  >  (Un) Subscribe thread alerts  
Subject:2 problems
Summary:Using script to Sync all the DB, local db returns Database down
Messages:2
Author:buxbeatz
Date:2015-04-30 12:14:03
 

  1. 2 problems   Reply   Report abuse  
Picture of buxbeatz buxbeatz - 2015-04-30 12:14:03
How can i use this script to sync the whole db?
I tried removing last field from master and slave set but it did not work.
I am currently trying to use this script to sync a local db on mamp and one online with the following script:

<?php
include "sync.php";

$sync = new SyncronizeDB();
//masterSet(dbserver,user,password,db,table,index)
$sync->masterSet("localhost","root","root","GB", "item");
//serverSet(dbserver,user,password,db,table,index)
$sync->slaveSet("XXX","XXX","XXX","XXX", "item");
//syncronizing the slave table with the master table (at row level)
$sync->slaveSyncronization()

?>

but page returns me :Database down
the local and online DBs are 100% working.

Thank you

  2. Re: 2 problems   Reply   Report abuse  
Picture of Nitesh Apte Nitesh Apte - 2015-05-03 12:29:12 - In reply to message 1 from buxbeatz
Hi

Just saw your message.

I think the error either of the db has no privilege to connect remotely. Please check the settings for both the db.