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

Re: Cant change anything via web?

2003-01-17 Thread Ferhat Can
sn't work either. I > dont knwo whats wrong.. but the only way I can edit my DB is to do it via > mysqladmin ON the linux box > > -Thanks oin advance > Tyler > > - > Before posting, please che

Re: phpmyadmin and mysql

2003-01-08 Thread Ferhat Can
Hello Martin, Your problem is related to PHP not MySQL. You should check the max_post_size directive in yor php.ini file. AFAIK, this limit is set to 8M. If you decreased the size, increasing it may solve your problem. max_post_size controls the maximim POST size you can do, and if you

Re: query only returns one row

2003-01-06 Thread Ferhat Can
Hi Chris, You need to use a while loop to fetch all of the records returned in the SELECT statement in PHP, as follows: \n", $row["DBID"]; printf("First Name: %s\n",$row["FIRST_NAME"]; printf("Last Name: %s\n", $row["LAST_NAME"]; } ?> - Original Me

Re: mysql web-based admin tool?

2002-01-29 Thread Ferhat Can
Hi, The most widely used tool to reach MySQL over PHP is phpMyAdmin. You can obtain it from http://www.phpwizard.net/projects/phpMyAdmin/ - Original Message - From: "Ed Lazor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 5:53 PM Su

Re: localhost problem

2001-11-21 Thread Ferhat Can
It seems at least one of your username and/or password is not as you might think. You should find the my.ini file, which is either should be in C:\Windows for M$ Windows'98, and change your username-password info. After relaoding mysql, it should function. Regards - Origi

Re: Automatic Mathmatical Computation

2001-10-24 Thread can
I think u cannot do automatically, since MySQL does not support table trigger or view. U can only get value C by select statement, otherwise u need to update the column C by another processing. Best regards, Kenneth. - Original Message - From: "Kodrik" <[EMAIL PROTECTED]

XML support

2001-10-19 Thread can
When will mysql support XML with function same as Oracle XSU? Kenneth. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this t

Re: Party!!!

2001-10-05 Thread can
e might have too many > people to hold just on one server. I may have to host it at brinkster.com. > They have dedicated servers there. Yeah, I'll just do that. This will be > great. I'll have download links to all binaries (Linux, Win32, etc) and > everyone can chat, and have

update support sub-queries?

2001-09-29 Thread can
Hi all, I am new in mysql and want to analyse between some popular databases. I have a SQL: update ta set f1 = ( select af1 from tb where ta.id = tb.id ); It can be done in postgreSQL and Oracle. How can I do the same tasks in MySQL without using Perl? Is it possible to do this tasks just