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

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:

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 have

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

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

Re: How to verify if backup is ok?

2013-02-18 Thread Johan De Meersman
- Original Message - From: Rafał Radecki radecki.ra...@gmail.com 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