Paul, It really did the trick. Thanks.
Regards, Pae ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Pae Choi" <[EMAIL PROTECTED]>; "Keith C. Ivey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 10:59 AM Subject: Re: [MySQL v3.23.53a] BLOB Data and Table Size > At 10:36 -0800 11/26/02, Pae Choi wrote: > >First of all, thanks for your reply as well as a pointer to the Doc. > > > >I tried the "OPTIMIZE" command as follows: > > > >mysql> optimize table gallery; > >mysql> optimize table gallery2; > > > >Both does not contain any entry since I deleted the BLOB data. > >But the size of tables, "gallery.db" and "gallery2.db" does not > >decresed. It remains as it was. > > > >Any comments? Thanks. > > > > > >Pae > > > >P.S.: The table is created with "type=bdb" option as: > > > > CREATE TABLE ... TYPE=BDB; > > OPTIMIZE performs defragmentation only for MyISAM tables. > You can shrink your tables by dumping and reloading them: > > mysqldump --opt db_name gallery gallery2 > dump.sql > mysql db_name < dump.sql > --------------------------------------------------------------------- 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