Shutdown the mysql server Goto the datadir (/var/lib/mysql) Goto the db directory Type myisamchk -r -S -a *.MYI this will reclaim the bad blocks caused by the delete.
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Iago Sineiro [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, October 28, 2003 9:52 AM -->To: MySql Mail List -->Subject: Howto reduce size of MYISAM files after deleting records? --> -->Hi. --> -->I delete a lot of records of one MyISAM table in MySQL 4.0.16. After that -->I -->execute mysqladmin refresh and now the size of the files of the table is -->the -->same than before. --> -->Is something wrong or is necessary doing something more to reduce the -->size -->of the files? --> -->Thanks in advance. --> -->Iago. --> --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
