"[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]