Re: MySQL database synchronization

2008-01-28 Thread Ananda Kumar
manually apply bin-logs from one site to other, but this is little complicated and need precise scripting taking care of all the bin-log position. regards anandkl On Jan 25, 2008 4:17 AM, C K <[EMAIL PROTECTED]> wrote: > I have a problem related with 2 mysql database synchronization. We ar

MySQL database synchronization

2008-01-25 Thread C K
I have a problem related with 2 mysql database synchronization. We are using a 256kbps internet at our mfg. site and a 2mbps internet connection at our HO. We are using MySQL5.0.45 for our ERP application. We want to work from both locations at a time through ERP software. For this we are trying

My SQL Database Synchronization Question

2004-02-04 Thread Paul Maine
I have two MySQL databases that are networked together. If changes can be made independently to each of the databases - what is the best way to synchronize them? How can I synchronize them in real time? If the network link goes down, can the synchronizations be placed upon a queue until the connect

DATABASE SYNCHRONIZATION TECHNIQUES OVER THE INTERNET

2003-07-03 Thread Priya Manivannan
Hi, I have a setup that consists of two MySql Database Server. Server A(WEB DB) is in web hosting location , runs behind a websever. Server B(LAN DB) is in my LAN. My requirment is synchronize both(WEB DB and LAN DB) databases over the internet. I am thinking of the following approaches. 1) D

Re[6]: [PHP-DB] database synchronization

2002-10-29 Thread Martin Hudec
Hello, see below... -- Best regards, Martinmailto:corwin@;corwin.sk Tuesday, October 29, 2002, 10:51:17 AM, you wrote: PL> Hi PL> If the records are all independant - ie travel agent (TA) A has their own PL> records and so does TA B then REPLACE INTO MainDB SELECT

RE: Re[4]: [PHP-DB] database synchronization

2002-10-29 Thread Peter Lovatt
1-242-1473 --- -Original Message- From: Martin Hudec [mailto:corwin@;corwin.sk] Sent: 29 October 2002 09:18 To: Peter Lovatt Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re[4]: [PHP-DB] database synchronization Hello Peter, okay :)))so far I understand...buth

Re: database synchronization

2002-10-29 Thread Jeremy Zawodny
On Tue, Oct 29, 2002 at 01:02:51AM -0800, Lalit Chandwani wrote: > Hi all, > > i have a mysql database on my local machine , the same database is > my server i want to synchronize the datbases both side. > > is there any login or tool or mysql support for database > synch

Re[4]: [PHP-DB] database synchronization

2002-10-29 Thread Martin Hudec
Hello Peter, okay :)))so far I understand...buthmmm let me explain I have server of travel agencies records (we need to update this, so it is slave) with stable IPand then bunch of other computers (from these we are updating...so they are all masters) in various travel agencies...

database synchronization

2002-10-29 Thread Lalit Chandwani
Hi all, i have a mysql database on my local machine , the same database is my server i want to synchronize the datbases both side. is there any login or tool or mysql support for database synchronization thanks in advance. = --- Dream Team Network Solutions Pvt. Ltd., C-97

Re: Database synchronization

2002-02-17 Thread MySQL
In Re: Database synchronization, <[EMAIL PROTECTED]> wrote: > >On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote: > >> I'd like to connect a local sql server to a remote server and get 1 >> database synchronized between them. For various reasons, I need to &g

Re: Database synchronization

2002-02-17 Thread Jeremy Zawodny
On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote: > I'd like to connect a local sql server to a remote server and get 1 > database synchronized between them. For various reasons, I need to > try to run this from within the sql protocol (i.e. no ftp, etc.). Okay. > Replication is not the a

Database synchronization

2002-02-14 Thread MySQL
I'd like to connect a local sql server to a remote server and get 1 database synchronized between them. For various reasons, I need to try to run this from within the sql protocol (i.e. no ftp, etc.). Replication is not the answer, and I can only work with one database at a time, so a SELECT is

Re: Database Synchronization

2001-12-07 Thread Michael Brunson
On Fri, 7 Dec 2001 03:07:56 -0800 (PST), Pragneshkumar Gandhi <[EMAIL PROTECTED]> wrote: | Hi All | I am New Subscriber to this mailing List. | This is Pragneshkumar from India. | | I have one Application Which are wriitten in java/jsp and | using mysql as db. | | Now this application is running

Database Synchronization

2001-12-07 Thread Pragneshkumar Gandhi
Hi All I am New Subscriber to this mailing List. This is Pragneshkumar from India. I have one Application Which are wriitten in java/jsp and using mysql as db. Now this application is running on net as well as in my intranet meand it is running on remote server as well as local server INDEPENDET

Database Synchronization

2001-11-08 Thread Tim Cowan
Hi Is it possible to synchronize databases. Let me tell you the scenario. The client lives out of town and wants to do point-of-sale at their place of business. Internet connection is not very reliable. They already have a comprehensive database that runs at an ISP in town. I would like to s

Re: database synchronization

2001-10-31 Thread Jeremy Zawodny
On Wed, Oct 31, 2001 at 04:28:27PM +0200, Vyacheslav I. Raytsin wrote: > Hello guru, > > It is not appropriate to me to use standard replication mechanism of > MySQL. because the interactions between master server and slave > server will be too busy. > > Is any possibility > 1. to replicate da

database synchronization

2001-10-31 Thread Vyacheslav I. Raytsin
Hello guru, It is not appropriate to me to use standard replication mechanism of MySQL. because the interactions between master server and slave server will be too busy. Is any possibility 1. to replicate data over certain period of time ( I need period 24hours) 2. some how to replicate lates