----- Original Message ----- > From: "Reindl Harald" <h.rei...@thelounge.net> > > impossible with innodb > > * dump > * delete > > with myisam you could stop the server and move the databasedir > do not try this with innodb even with innodb_file_per_table!
Mmh, it should be pretty easy to write a small script that creates a new database named <oldname>_offline and renames all tables into it, no? Shame that "rename database" doesn't exist any more :-) -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql