Hi, Le Fri, 16 Jan 2009 12:46:29 +0100, Zeno Tajoli <tajoli@cilea.it> a écrit :
[12 Jul 2004 15:51] Heikki Tuuri
If you use MySQL-4.1.3, define
innodb_file_per_table
in my.cnf, and do OPTIMIZE TABLE, the operating system will get the disk space back. That is because the table is stored in its own .ibd file, and OPTIMIZE will rebuild the whole table to another .ibd file, rename the .ibd file, and delete the old .ibd file.
2) buil a script to drop / rewrite tables. The hack is to rewrite tables in MyIsam type and after transform them into InnoDB http://www.saturn.in/portfolio/mysql.shtml
Build a script should be the solution, BUT do not rewrite tables un MyIsam, it doesn't support the foreign keys, so they will be dropped. The solution I found in mysql website, is to mysqldump all the database, drop/create the database, and reinsert all the datas. bests, -- Nahuel ANGELINETTI