Re: How to verify if backup is ok?

2013-02-18 Thread Johan De Meersman
- Original Message - > From: "Rafał Radecki" > > 3) drop mysql and app databases; > 4) restore them from backup; Instead of dropping the DBs, simply restore to another database or server. That will also allow you to perform a comparison using some graphical tool, or if that fails mysql

Re: MySQL Client (libmysqlclient) compatibility policy

2013-02-18 Thread Sebastien FLAESCH
On 02/18/2013 12:14 PM, Noel Butler wrote: On Mon, 2013-02-18 at 10:57 +0100, Sebastien FLAESCH wrote: I have several versions of MySQL installed on my Linux, and it appears that the libmysqlclient versions have changed in the 5.x version line: /opt3/dbs/mys/4.1.24/lib/libmysqlclient.so.14 /op

Re: MySQL Client (libmysqlclient) compatibility policy

2013-02-18 Thread Noel Butler
On Mon, 2013-02-18 at 10:57 +0100, Sebastien FLAESCH wrote: > I have several versions of MySQL installed on my Linux, and it appears > that the libmysqlclient versions have changed in the 5.x version line: > > /opt3/dbs/mys/4.1.24/lib/libmysqlclient.so.14 > /opt3/dbs/mys/5.0.90/lib/libmysqlclien

Re: MySQL Client (libmysqlclient) compatibility policy

2013-02-18 Thread Reindl Harald
Am 18.02.2013 10:57, schrieb Sebastien FLAESCH: > Hi all, > > What is the compatibility policy regarding the MySQL C API library? > > I could not find the rules in the documentation. > > I have several versions of MySQL installed on my Linux, and it appears > that the libmysqlclient versions h

MySQL Client (libmysqlclient) compatibility policy

2013-02-18 Thread Sebastien FLAESCH
Hi all, What is the compatibility policy regarding the MySQL C API library? I could not find the rules in the documentation. I have several versions of MySQL installed on my Linux, and it appears that the libmysqlclient versions have changed in the 5.x version line: /opt3/dbs/mys/4.1.24/lib/li

How to verify if backup is ok?

2013-02-18 Thread Rafał Radecki
Hi All. I have a development database which is replicated to a slave. Backup is taken daily from this slave. I need to test if the restore procedure is ok. I would like to: 1) block all application access (stop services + iptables block) to the database and lock it read only; 2) make a backup with