Re: Chronicle of fixing broken replication, and a question

2011-07-26 Thread Reindl Harald
Am 26.07.2011 19:13, schrieb Todd Lyons: > On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald wrote: >>> 1. I did a full copy of the running master database server using >>> xtrabackup to a backup server via nfs. It took 2 hours, of which the >>> last 15 minutes did a write lock of the entire serv

Re: Chronicle of fixing broken replication, and a question

2011-07-26 Thread Todd Lyons
On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald wrote: >> 1.  I did a full copy of the running master database server using >> xtrabackup to a backup server via nfs.  It took 2 hours, of which the >> last 15 minutes did a write lock of the entire server as it copied >> over the *.frm files and the

Re: Chronicle of fixing broken replication, and a question

2011-07-26 Thread Reindl Harald
Am 26.07.2011 16:18, schrieb Todd Lyons: > 1. I did a full copy of the running master database server using > xtrabackup to a backup server via nfs. It took 2 hours, of which the > last 15 minutes did a write lock of the entire server as it copied > over the *.frm files and the few myisam tabl

Chronicle of fixing broken replication, and a question

2011-07-26 Thread Todd Lyons
Yeah it happens to all of us. Some master->slave replication system breaks and goes unnoticed. In my case, I had a monitoring script, but it was being called with a --verbose flag, and internally that "verbose" was being mapped to "debug", and the routine to notify sysadmins of broken replication

Re: Free Navicat

2011-07-26 Thread Adarsh Sharma
there are so many dependencies for mysql-workbench and i find it difficult after this error : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.33b-1el6.x86_64.rpm error: Failed dependencies: libcrypto.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 lib

Re: Free Navicat

2011-07-26 Thread Adarsh Sharma
Thanks Walter, but I tried all the hooks & crooks, In Ubuntu , following error occurs : root@lin-ws-15:~# apt-get install mysql-workbench Reading package lists... Done Building dependency tree Reading state information... Done E: Couldn't find package mysql-workbench root@lin- I think my

RE: Free Navicat

2011-07-26 Thread Martin Gainty
you will need the x86-64bit distro which contains the x86-64 bit distribution of libatkmm-1.6.so.1RPMs are error prone because they are version unaware..navicat should refactor their install to a version aware utility such as maven IMHO Martin __ Verz

Re: Free Navicat

2011-07-26 Thread Walter Heck - OlinData.com
Try using yum to install your rpm, it should search for the dependencies and install them if I'm not mistaken (or just don't use centos for desktop OS and save yourself all kinds of misery altogether :P). cheers, On Tue, Jul 26, 2011 at 14:35, Adarsh Sharma wrote: > ** > Ya , I know that but I f

Re: Free Navicat

2011-07-26 Thread Adarsh Sharma
Ya , I know that but I fail to install Mysql-workbench in Linux Systems ( CentOS , Ubuntu ) Error shows like below : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm error: Failed dependencies: libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.3

Free Navicat

2011-07-26 Thread Adarsh Sharma
Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL refusing to accept passwords

2011-07-26 Thread misiaq
"Shawn Green (MySQL)" pisze: (...) > You can be the correct > user, using the correct password but you may not be allowed (by the host > pattern) to login from the machine from which you are attempting to login. > It could be the case you got your account setup as username@localhost and it