Newer versions of mysqldump add this to the top of the dump file: SET FOREIGN_KEY_CHECKS = 0;
and then at the end of the file: SET FOREIGN_KEY_CHECKS = 1; On Thu, 2007-03-29 at 10:02 -0500, Curtis Maurand wrote: > I don't know if anyone else is having this trouble, but mysqldump for me > does not dump the database in the correct order in order to load the > tables back in. Usually I get failures for dependency issues (tables > depending on other tables that haven't been created, yet.). I've found > that I've had to dump the tables one at a time and then restore them the > proper order. > > Curtis > > Michael Dean wrote: > > Sunny Koh wrote: > >> Thanks Paul, was asking because wondering if I did the correct thing > >> or not or should I omit or add additional parameters. > >> > >> > >> Paul J Stevens wrote: > >>> What's wrong with a simple > >>> > >>> mysqldump -h $host -u $user -p$pass --single-transaction --opt $db > >>> > >>> > >>> Sunny Koh wrote: > >>> > >>>> Paul, > >>>> > >>>> What I meant was the mysqldump options as well. Currently I have > >>>> mysqldump -u $MyUSER -h $MyHOST -p$MyPASS $db --opt > >>>> --hex-blob --max_all > >>>> owed_packet=16M --quote-names > >>>> > >>>> But Is this the correct way? > >>>> > >>>> Paul J Stevens wrote: > >>>> > >>>>> Load the 2.0.11 database > >>>>> Run the migrate_from_2.0_to_2.2.mysql > >>>>> run dbmail-util -by > >>>>> > >>>>> > >>>>> Sunny Koh wrote: > >>>>> > >>>>> > >>>>>> Hello All, > >>>>>> > >>>>>> I have just manage to certify the platform to run DBMail on a > >>>>>> fresh OS > >>>>>> Image (Gentoo 2006.1 Stage 2 with full rebuild) and would like to > >>>>>> know > >>>>>> what is the best options to copy the database from the old harddisk > >>>>>> image to the new one and which script I use to upgrade from > >>>>>> 2.0.11 to > >>>>>> 2.2.4. I know I should be using the mysqldump command but with what > >>>>>> parameters. Any suggestions from the community? > >>>>>> > >>>>>> > >>>>> > >>>> > >>> > >>> > >>> > >> > >> > > does anybody have any concurrency data benchmarks between mysql and > > postgresql with dbmail??? > > MIchael > > _______________________________________________ > > DBmail mailing list > > [email protected] > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
