List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:July 20 2012 9:20am
Subject:Re: Disable DB without deleting data
View as plain text  
----- Original Message -----
> From: "Reindl Harald" <h.reindl@stripped>
> 
> 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
Thread
Disable DB without deleting dataKirk Hoganson19 Jul
  • Re: Disable DB without deleting dataReindl Harald19 Jul
    • Re: Disable DB without deleting dataJohan De Meersman20 Jul
      • Re: Disable DB without deleting dataReindl Harald20 Jul
        • RE: Disable DB without deleting dataRick James20 Jul
          • Re: Disable DB without deleting dataReindl Harald20 Jul
          • Re: Disable DB without deleting dataKirk Hoganson20 Jul
            • Re: Disable DB without deleting dataReindl Harald20 Jul
              • Re: Disable DB without deleting dataAndrew Moore20 Jul
  • Re: Disable DB without deleting dataAndrew Moore19 Jul