thx thx :D thats work right.
the only problem is that mysqldump dont write the 'set FOREIGN_KEY_CHECKS' sentences until version 4.1.1: "To make it easier to reload dump files for tables that have foreign key relationships, mysqldump automatically includes a statement in the dump output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1." :).. but dont worry i write the sentences by hand. thx d2clon On Thursday 24 June 2004 11:44, Egor Egorov wrote: > "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > i have read multiple websites and posts.. and this mail list archive > > but i have not found the answer to the question: > > > > how is it possible to do a backup of a innodb table? > > > > > > > > i have read: "try to use mysqldump.." but this does not work right > > i have read: "try to use mysqldump --single-transaction ..." but i dont > > see any difference.. and doesnt work right too > > i have read: "use this: http://www.innodb.com/order.php .." but it isnt > > free :/ > > > > > > the problem is not how to do the backup.. but recovering from it.. > > because it complains about the foreign keys. > > How to restore tables that have foreign key relationships is described at: > http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html > > You should set FOREIGN_KEY_CHECKS to 0 before restoring tables. > > > and then i think: > > how is it possible that i cant do backup, and recover it, of my innodb > > tables? > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
