Use mysql and do a "delete from vlog" and it will purge all of the records.
There is a utility in the mysql/bin directory called myisampack that will compact the file again. Ross Davis DataAnywhere.net 250-470-9192 ChaletsOnline.com is coming soon Don't you deserve a vacation! -----Original Message----- From: Ed - Vpop [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 8:29 AM To: [EMAIL PROTECTED] Subject: [vchkpw] vlog.myd My vlog datafile is now over a gig. How can I delete it elegantly? Is it acceptable to stop mysql delete the file then restart mysql and hope it starts back up again? Thanks in advance, Ed Compass Communications Seattle, WA