0
votes
1answer
285 views

synchronous the databases at real time [duplicate]

I have two databases, one in the domain and managed by phpMyAdmin, and the other is located on the local server. I want make the local one as master and the other reside in the domain as slave. With ...
-1
votes
2answers
182 views

How can I synchronous two databases

I have two databases. First one is local and the other is at Internet, in my domain. I want to synchronous two databases. Is it possible to do so ? How can I synchronous two databases ? Some detailed ...
-2
votes
1answer
155 views

Database synchronization [closed]

What is the most efficient way to sync/mirror certain data from a large remote database with a local version? The scenario is, there is a central remote database on a hosted server, which will share ...
0
votes
1answer
333 views

MySQL replication re-sync

I'd like to set up a zero-maintenance hands-off MySQL replication regimen for backup purposes. It's been my experience, though, that these things inevitably eventually get out of sync. Perhaps it's ...
1
vote
2answers
3k views

What can I really do with percona toolkit's pt-table-sync?

I have been looking for a tool to synchronize tables from 2 different databases and found pt-table-sync. I read the documentation and got confused: they mostly use examples referring to a replicated ...
0
votes
1answer
693 views

MySQL Database synchronizing with local and remote with c#

I've posted this here as its more of a mysql questions than c#, I have written some software that runs a local instance of mysql when it first starts, now once mysql is up I would like to synchronize ...
0
votes
2answers
692 views

How do I sync a subset of tables between two databases on the differnet mysql database server?

I have the main MySQL database which has the following columns in one of the car table: +---------------+-----------------+------+ |carId |name |model | ...
2
votes
2answers
222 views

Partial sync of Mysql databases on two remote computers

Does mysql replication supports delayed sync if remote slave server is OFF? For example I want to make my developing server have a fresh copy of databases each morning. It should be partial sync, ...
0
votes
1answer
828 views

How to synchronize local MySQL (full access) to remote one (PHP only)

Our scenario is a local Linux MySQL server on which we can do whatever we want including installing stuff and setting up cronjobs, and a remote one which we can access only via PHP. The remote one is ...
1
vote
0answers
216 views

Sync Exchange mailbox with MySQL database?

I am building a small web portal for my staff which includes a task/meeting scheduler built in php with mysql backend. We also use Exchange 2003, users have OWA and mainly use that for scheduling. ...
0
votes
1answer
63 views

Mysql, automate copy data database to temporary database

I have a case like this: I have 2 database on 1 server, say it db1 and db2 db2 will be a copy of db1 data from db1 copied automatically to db2 data from db2 will not sync with db1 (db2 just a test ...
0
votes
2answers
153 views

File synchronization between web servers

Me and a friend has two servers (linux/gentoo) - both has ADSL connections (16Mbit/s download - 512Kb/s upload) and they're located several hundred kilometers away. Since our upload bandwidth is way ...
1
vote
1answer
2k views

Synchronizing local mysql database with remote one with a script or automatically? [closed]

Is there a way to sync a MySQL database with a remote one either automatically or with a script? The data is not time sensitive, but I don't want to have to export it out of the local database and ...
0
votes
1answer
409 views

Syncronizing mySQL database using myPHPAdmin

I'm trying to synchronize two mySQL databases - more specifically, copy the contents of one to another. I have been using the myPHPAdmin Synchronize function but the target database does seems to ...
3
votes
3answers
532 views

How can I set up a mirror site of PHP & MYSQL between two distant sites?

I have a site which is located in US and I want to set up a mirror site in China, the site is using PHP + MYSQL and the network quality between two servers is terrible. I tried set up a database-sync ...
1
vote
1answer
141 views

Database redundancy, more than just daily

We're an online store and backups are made daily. The problem is that if our database is lose, we lose all database changes/orders that were made on our site that day. We're tossing around the idea ...
2
votes
1answer
1k views

How to setup two mysql servers in Synchronization mode

Infrastructure I have two database servers, running on two different boxes. One works as a primary database for my web application and other works as secondary database. Secondary data base is ...
1
vote
3answers
1k views

MySQL replicate structure only

Can I set up MySQL as a slave only replicating structure changes? (CREATE / ALTER TABLE etc.). I've got 2 reasons for this: Multiple developers with development branches in code which should always ...
0
votes
3answers
1k views

synchronize 2 mysql servers (all databases + users)

We want to sync 2 mysql servers with eachother (products & qa system). We would like to sync all databases, data and users of the production machine to a secondary mysql machine. What would be ...
1
vote
6answers
1k views

MySQL replication out of sync

I have a master-master replication system. However, due to an auto-increment issue, I got an error in replication...and it stopped replicating. Someone told me to do: stop slave; SET GLOBAL ...
0
votes
1answer
168 views

Sync mysql databases to master server

Hi I need to do a database synchronization from each store to central store. Each store employee should be able to do this sync once or twice a day, due ISPs unavailability here. Owner would check at ...