At 15:45 +0100 2/4/02, Skriniar Gregor wrote: >Dear all, > >I experienced some problems with using MySQL API: >My problem is that if I don't use database a long time it is disconnected and
That's how it's supposed to behave. What's the bug? If your application really needs to hold the connection open for abnormally long times, you could have it send the server a trivial query every now and then. (Say, "SELECT 1") >when I try to connect again at first I use method mysql_ping(), >which reopens connection and that's the point. Please see next code >of MySQL API: [clipped] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
