List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 29 2001 9:56pm
Subject:Re: File size problem!
View as plain text  
In the last episode (Mar 29), Guanglin Dong said:
> I have problem about the mysql database file. After I deleted a lot
> of table records, the database data and index file still have the
> same size as that before I deleted a lot of records. Anybody knows
> how to shink the database file size after I delete a lot of records?
> Thanks in advance.

OPTIMIZE TABLE tablename

-- 
	Dan Nelson
	dnelson@stripped
Thread
File size problem!Guanglin Dong29 Mar
  • Re: File size problem!Jeremy D . Zawodny29 Mar
  • Re: File size problem!Dan Nelson29 Mar
RE: File size problem!Guanglin Dong30 Mar