MySQL and Syslog

Hi All, Anyone had tried to push all MySQL logs to the centralized syslog server? Can you share with me how did you do it? I have centralized syslog (rsyslog-3.22.1-3.el5) server who resides separately and a remote MySQL server (mysql-server-5.0.77-4.el5_4.2) on other node. How to accomplish this

To get Processlist and Status of MySQL ?

Hi All, What is the other way to get the *processlist* and *status* of mysql server on event that the mysql server cannot be able to reach due to hung or crashed? Cheers, James

Re: To get Processlist and Status of MySQL ?

tool/apps do you use? Thanks. James On Tue, May 18, 2010 at 5:06 AM, Raj Shekhar wrote: > In infinite wisdom James Corteciano wrote: > > > [1 ] > > Hi All, > > > > What is the other way to get the *processlist* and *status* of mysql > server > > on event t

Got error 139 from storage engine (InnoDB)

Hi All, I have received error message "ERROR 1030 (HY000) at line 167: Got error 139 from storage engine" when importing dump database to MySQL server. The MySQL server is using InnoDB. I have google it and it's something problem on exceeding a row-length limit in the InnoDB table. Any have idea

Re: Got error 139 from storage engine (InnoDB)

has 24GB memory and Quad-Core CPU. The platform is RHEL 5.5 x64 and mysql-server-5.0.77-4.el5_4.2. *Rob Wultsch *and Prabhat Kumar, thanks for your response. Regards, James On Tue, Jul 6, 2010 at 5:19 PM, Joerg Bruehe wrote: > James, all, > > > James Corteciano wrote: > >

MySQL Workbench - libmdcanvasgtk.so.0: undefined symbol: pixman_image_unref

Hi All, I have downloaded mysql-workbench-oss-5.2.14-1rhel5.i386.rpm to test the MySQL GUI tools. I've installed it with no errors. When I run the 'mysql-workbench' command, it gives me error message: # mysql-workbench /usr/bin/mysql-workbench-bin: symbol lookup error: /usr/lib/mysql-workbench/li

How to dump MySQL data on remote server using mysqldump

Hi, I have mysql server separated from web server. My problem is, when I dump the data from database using the command "mysqldump -uuser -p -h mysql_server -t -T /tmp/dbname database_name" on web server, all data were dumped to the /tmp/dbname of mysql server and not inside of web server. [web]$