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)

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/

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 :slight_smile:


Cheers / Saludos,

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