On Tue, 26 Mar 2002 18:44:54 -0800 (PST) Foo Yong Choon <[EMAIL PROTECTED]> wrote:
> My application cannot connect to the database and > perform SQL qurey after usuualy after a day. > > I heard that mysql automatically close connection > after 8 hrs of inactivity. > > Hope u can email me how to prevent the auto closing or > any alternative method. Thanks in advance! edit your my.cnf and set XXX with your needs set-variable = interactive_timeout=XXX XXX in secs -- Linux: Where Don't We Want To Go Today? -- Submitted by Pancrazio De Mauro, paraphrasing some well-known sales talk --------------------------------------------------------------------- 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