List:General Discussion« Previous MessageNext Message »
From:Irwin Boutboul Date:September 16 2003 11:13pm
Subject:mysqldump with innoDB
View as plain text  
It looks like the dump works... however the way it is made, there is no 
way to use it to recreate the database because key constraints fail. The 
dump contains table creations in an order which does not respect key 
constraints.

Is there any work around to rebuild a database with innodb tables ? Or 
shall I first move every table to myIsam and then do the dump, re-import 
and finally reconvert tables to innodb ? 

Thanks,


Irwin Boutboul
Advanced Internet Technology
150 Kettletown Road, B2-N06
Southbury, CT 06488
Phone: 203-486-5614
Thread
• mysqldump with innoDBIrwin Boutboul17 Sep
  • Re: mysqldump with innoDBPaul DuBois17 Sep
    • Re: mysqldump with innoDBDaniel Kasak18 Sep
      • Re: mysqldump with innoDBPaul DuBois18 Sep
      • Re: mysqldump with innoDBFranky18 Sep
  • Re: mysqldump with innoDBHarald Fuchs18 Sep
  • Large number of DatabasesRichard18 Sep
  • Re: Large number of DatabasesHarald Fuchs18 Sep
    • Re: Large number of DatabasesGustavo A. Baratto18 Sep
      • Re: Large number of DatabasesJeremy Zawodny18 Sep
        • Re: Large number of DatabasesGustavo A. Baratto18 Sep
          • Re: Large number of DatabasesDan Nelson18 Sep
          • Re: Large number of DatabasesJeremy Zawodny18 Sep