Re: FN-FORUM MySQL Synchronisation

date posted 23rd April 2001 07:59

Hi Darren,

If you want to Sync to a record level, make sure you have a "Last Edit Date"
field in your table, then when syncing, just keep the latest one,
If you want to Sync down to a Field Level, you should also maintain a
"Transaction Log" which will hold info on the "Last Edit Date" for each
field.(This Helps when more than one "remote" database in use)

A bit obvious I suppose, but hope it Helps

Mark Redman



----- Original Message -----
From: "Darren Spink" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, April 22, 2001 4:04 PM
Subject: FN-FORUM MySQL Synchronisation


> I was wondering if anyone has tried/suceeded at this before. I am
> developing a mySQL web site, but it would be very handy if I could have it
> available off line too. Maybe be able to perform some sync between the
> resident and the hosted site. Obviouslt the only sync needed would be the
> database and any link/picture files.
>
> Has anyone done this before ? any tips on doing this ??
>
> TIA
>
>
> Regards
>
>
> Darren Spink
> http://www.arkad.leeds.co.uk
>
>
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html
>