Re: MySQL and Syslog

2010-05-15 Thread Dan Nelson
In the last episode (May 15), James Corteciano said: > 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 (m

Re: C API Function for count(*)

2010-05-15 Thread Tim Johnson
* Bob Cole [100515 06:58]: > You might get closer to what you want if you put your command in a text file > and run it from the command line. > On a Mac OS X, I put a similar command: > select count(*) from testTable; > into a small text file: > testCount.txt > and ran this command fro

Re: C API Function for count(*)

2010-05-15 Thread Tim Johnson
* Dan Nelson [100514 21:38]: > > You can't do it with one function call, but you can do it, since the MySQL > cli was able to print "16" in your example above, and it was written in C. > Take a look at mysql_store_result(), mysql_num_fields(), > mysql_field_count(), mysql_fetch_row(), and mysql_

Re: C API Function for count(*)

2010-05-15 Thread Bob Cole
You might get closer to what you want if you put your command in a text file and run it from the command line. On a Mac OS X, I put a similar command: select count(*) from testTable; into a small text file: testCount.txt and ran this command from the Terminal: mysql -u username -pp

Re: libexec/mysqld: unknown option '--skip-bdb'

2010-05-15 Thread Kris
Jörg, thanks again for your help and your patience with this issue. You also caught oversights with strace and clarified that this is not a PATH issue. I've filed it at: http://bugs.mysql.com/bug.php?id=53667 > You don't state it explicitly, but I take your text to mean > "If the MySQL tools are

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 this