List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 25 2002 4:15pm
Subject:re: re: innodb tables backup
View as plain text  
At 12:44 +0200 10/25/02, Natale Babbo wrote:
>i tried it ... but nothing to do!
>when mysql parse the foreign key in the create table i
>get the error.
>
>perhaps i'm wronging in restoring tables/db!
>
>i use this method:
>shell> mysql -u <user> -p<password> < <dump file>
>
>is it wrong?

Depends.

- DId you add the SET FOREIGN_KEY_CHECKS = 0; statement to the dump
   file?
- What version of MySQL do you have?

If you added the statement, and you have a recent enough version of
MySQL, then it will work not only for the INSERT statements in the
dump file, but for the CREATE TABLE statements as well.

>
>thanks.
>Natale Babbo
>
>
>
>  --- Victoria Reznichenko
><victoria.reznichenko@stripped> ha scritto: >
>Natale,
>>  Friday, October 25, 2002, 10:08:00 AM, you wrote:
>>
>>  NB> ok ... that's right for data (insert into ...)
>>  ... but
>>  NB> i get the error before ... when mysql try to
>>  create
>>  NB> child table:
>>  NB> CREATE TABLE ... idParent BIGINT, INDEX
>>  idpar_ind
>>  NB> (idParent), FOREIGN KEY (idParent) REFERENCES
>>  NB> parent(id)
>>  NB> .. when mysql parses the foreign key, parent
>>  table
>>  NB> doesn't exist yet!
>>
>>  No, it's true not only for data.
>>  Put
>>
>>  SET FOREIGN_KEY_CHECKS=0;
>>
>>  in the dump file and then restore tables. It works
>>  fine for me.
>>
>>  NB>  --- Victoria Reznichenko
>>  NB> <victoria.reznichenko@stripped> ha scritto: >
>>  NB> Natale,
>>  >> Thursday, October 24, 2002, 10:57:00 AM, you
>>  wrote:
>>  >>
>>  >> NB> Anyone knows how to backup innodb tables in
>>  the
>>  >> right
>>  >> NB> sql order?
>>  >> NB> ... i mean ... to allow restoring correctly
>>  >> NB> without foreign key constraint violation (if
>>  in
>>  >> the
>>  >> NB> backup file ddl code for the child table is
>>  >> before ddl
>>  >> NB> code for the parent table i get an error).
>>  >>
>>  >> You can set up SET FOREIGN_KEY_CHECKS=0, in this
>>  >> case foreign key
>>  >> constraints will not be checked. It's supported
>>  >> since 3.23.52 and
>  > >> 4.0.3

Thread
innodb tables backupNatale Babbo24 Oct
  • re: innodb tables backupVictoria Reznichenko24 Oct
    • re: innodb tables backupNatale Babbo25 Oct
      • re: re: innodb tables backupVictoria Reznichenko25 Oct
        • re: re: innodb tables backupNatale Babbo25 Oct
          • re: re: re: innodb tables backupVictoria Reznichenko25 Oct
          • re: re: innodb tables backupPaul DuBois25 Oct
Re: InnoDB Tables BackupMichael T. Babcock24 Oct