RE: Queues on MySQL?

2008-07-02 Thread Jerry Schwartz
>-Original Message- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 01, 2008 5:26 PM >To: Jerry Schwartz >Cc: MySQL List >Subject: Re: Queues on MySQL? > >>>Thanks for the suggestion--is that essentially using >>>http://www.php.net/posix_mkfifo within PHP? >>> >> [JS] Yes, t

Mysqldump turn off quotes

2008-07-02 Thread Martin Gainty
How do I get mysqldump to turn off quotes e.g from INSERT INTO "table" to INSERT INTO table Thanks Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread up
It would appear that the problem isn't getting MySQL 3.23 and 5.0 to run on the same server with different ports and sockets, but rather getting mod_php to recognize both clients. phpinfo() shows only 3.23, since it's in the standard path. If anyone has experience getting two different vers

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread Curtis Maurand
Did you rebuild php against the 5.0 libraries as I suggested yesterday? If you didn't it will only recognize the 3.23 version. It will not be able to talk to the 5.0 version. Curtis [EMAIL PROTECTED] wrote: It would appear that the problem isn't getting MySQL 3.23 and 5.0 to run on the s

Re: Mysqldump turn off quotes

2008-07-02 Thread Dan Nelson
In the last episode (Jul 02), Martin Gainty said: > > How do I get mysqldump to turn off quotes e.g from > INSERT INTO "table" > to > INSERT INTO table http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_quote-names -- Dan Nelson [EMAIL PROTECTED] -- MySQL

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread up
No, because I fear that would break the existing customer php apps, which is the whole point of running two versions of MySQL. What I guess I need to know is if php's mysql and mysqli extensions can be made to recognize two different sets of client libs. Unless you're telling me that having

how to stay connected to remote mysql server?

2008-07-02 Thread Can-Hua Chen
I am using syslog-ng to pipe syslog entries to a remote mysql server. I would like to stay connected to remote mysql server, always trying to reconnect if disconnected due to network problem. Is there some mysql-internal mechanism to do this? Or must I write a script to do so? If a script is necess

Help with query MySQL and PHP

2008-07-02 Thread axis
Hi, I want to create a new column or table from queries of the values of columns I( already have. My table is : PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS products_id products_extra_fields_id products_extra_fields_value 1 1