Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 01-20-2004, 10:28 AM   #1
Registered: Mar 2002
Posts: 51

Rep: Reputation: 15
Arrow MySQL non-realtime table-by-table mirroring

Hi all,

I've got a development server and production server.
I want all web site changes to be done on the development server, tested, and synched to the production server.
For the moment, MySQL is what I'm concerned with.

The problem is that while all changes done by company staff to the database will be done on the local server, there is much data that will need to be entered on the remote server.
By and large, I believe I can separate tables into ones that need to be edited locally, and ones that need to be edited remotely.

So what I want is a solution that will let me mirror a single table from one server to another.

About the only thing I've thought of so far is to have a list of each type of table, and a script that manipulates the mysql client and mysqldump to connect to each server individually and do the necessary mirroring.

Any advice would be appreciated.
Old 01-20-2004, 12:11 PM   #2
Senior Member
Registered: Feb 2003
Location: The Arctic
Distribution: Fedora, Debian, OpenSuSE and Android
Posts: 1,820

Rep: Reputation: 46
I did something like this recently. We used PHP scripts to grab the data and compare records. Then any records not in the outer table were Inserted, and records found to be modified were updated. It's not too tough to set up in PHP. The only thing to watch for is performance issues (on big tables).


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with mysql table name mitrship Programming 2 07-25-2005 07:12 AM
getting the most frequent value from mysql table niehls Programming 4 01-29-2005 06:49 AM
MySQL db table tommytomato Linux - General 10 08-24-2004 05:57 AM
MySQL: Can't use '(' or ')' in table name Mikessu Linux - Software 0 08-03-2004 03:59 AM
How to import MS ACCESS Table including OLE filed into the MySQL Table ? myunicom Linux - General 1 11-28-2003 11:30 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:03 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration