Results 1 to 3 of 3

Thread: Keeping two mysql databases in sync asynchronously

  1. #1
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Keeping two mysql databases in sync asynchronously

    Hi,

    I have a database of my books in mysql, accessed with rekall (kde3),
    stored in my desktop. A copy of it is also in my laptop, done by simply
    copying over the entire folder "/var/lib/mysql/Biblioteca/" with mysql
    stopped - which is why I named the subject ...in sync asynchronously.
    The machines are independent and only interconnected at times.

    But I wonder if that is the proper way to do it. There might be
    problems, because the laptop uses 11.4 and the dektop 12.1. Perhaps I
    should use other methods to transfer only the data... :-?

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 12.1 x86_64 "Asparagus" at Telcontar)

  2. #2
    Yvon Nédonchelle NNTP User

    Default Re: Keeping two mysql databases in sync asynchronously

    Carlos E. R. a écrit :

    > Hi,
    >
    > I have a database of my books in mysql, accessed with rekall (kde3),
    > stored in my desktop. A copy of it is also in my laptop, done by simply
    > copying over the entire folder "/var/lib/mysql/Biblioteca/" with mysql
    > stopped - which is why I named the subject “...in sync asynchronously”.
    > The machines are independent and only interconnected at times.
    >
    > But I wonder if that is the proper way to do it. There might be
    > problems, because the laptop uses 11.4 and the dektop 12.1. Perhaps I
    > should use other methods to transfer only the data... :-?
    >


    I am doing the same between my home computer (OpenSuse 12.2) and my boat
    laptop (Windows XP) with mysql databases containing tidal currents and tides
    harmonic constants.
    It works fine as long as you only use ascii for table names and data because
    windows and Linux do not use the same char set.
    Databases are updated on the home computer and then copied on the boat
    laptop via a USB drive.

    Regards
    --
    Yvon.
    http://perso.numericable.fr/vertgalant/

  3. #3
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Keeping two mysql databases in sync asynchronously

    On 2013-02-17 11:21, Yvon Nédonchelle wrote:
    > Carlos E. R. a écrit :


    > I am doing the same between my home computer (OpenSuse 12.2) and my boat
    > laptop (Windows XP) with mysql databases containing tidal currents and tides
    > harmonic constants.


    Ah, then I'm good :-)

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 12.1 x86_64 "Asparagus" at Telcontar)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •