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
