Hi, Le Fri, 16 Jan 2009 12:46:29 +0100, Zeno Tajoli <taj...@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 _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
