How to dump MySQL data on remote server using mysqldump

2010-09-01 Thread James Corteciano
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]$

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

2010-07-11 Thread James Corteciano
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:

Re: Got error 139 from storage engine (InnoDB)

2010-07-06 Thread James Corteciano
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 joerg.bru...@sun.com wrote: James, all, James Corteciano wrote: Hi All

Got error 139 from storage engine (InnoDB)

2010-07-04 Thread James Corteciano
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: To get Processlist and Status of MySQL ?

2010-05-18 Thread James Corteciano
use? Thanks. James On Tue, May 18, 2010 at 5:06 AM, Raj Shekhar rajl...@rajshekhar.net wrote: In infinite wisdom James Corteciano ja...@linux-source.org wrote: [1 text/plain; ISO-8859-1 (7bit)] Hi All, What is the other way to get the *processlist* and *status* of mysql server

To get Processlist and Status of MySQL ?

2010-05-16 Thread James Corteciano
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

MySQL and Syslog

2010-05-15 Thread James Corteciano
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