MySQL purge logs

2008-05-11 Thread Kaushal Shriyan
Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html whats the exact syntax to purge this MySQL Binary Logs -rw-rw 1 mysql 701 1.1G May 5 07:39 host1-bin.000681 -rw-rw 1 mysql 701 1.1G May 5 09:09 host1-bin.000682 -rw-rw 1 mysql 701 1.1G May 5

Re: Help needed

2008-05-11 Thread Daniel Kasak
On Sat, 2008-05-10 at 20:59 +0400, Velen wrote: Hi, I'm testing a program and I need you assistance. Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program. Please supply a Linux version of your virus so I can test. -- Daniel Kasak IT Developer NUS Consulting Group

Re: MySQL purge logs

2008-05-11 Thread Dennis Yu
login MySQL with root and use: RESET MASTER that's all you need to do. Kaushal Shriyan wrote: Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html whats the exact syntax to purge this MySQL Binary Logs -rw-rw 1 mysql 701 1.1G May 5 07:39 host1-bin.000681

Re: Could somebody tell me how to get the time of a database?

2008-05-11 Thread Krishna Chandra Prajapati
show table status; On Mon, May 12, 2008 at 11:19 AM, Moon's Father [EMAIL PROTECTED] wrote: I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- I'm a mysql DBA in china. More about me just visit here: