Daniel Kasak wrote:
> Paul DuBois wrote:
>
>> If you have problems reloading the table due to the order
>> in which the InnoDB tables appear in the dump files, add
>>
>> SET FOREIGN_KEY_CHECKS = 0;
>>
>> to the beginning of the file before reloading it.
>>
> Our backups are quick large - over 500 MB. Opening the file and adding
> the above line at the top takes a lot of CPU time and memory - and when
> I'm restoring, I don't have a lot of time...
> Is there an easier way to get it there - can I 'cat' to the beginning of
> a file, or should I make my backup scripts cat the output of mysqldump
> to the end of a file with 'set foreign_key_check=0;' at the top? Maybe
> we could have a switch for mysqldump that does this for us?
>
quick solution:
put the line "SET FOREIGN_KEY_CHECKS = 0;" in a file (eg.header.txt) and
then:
cat header.txt mysql.dump >mysqlgood.dump
should take about 5 secs.
Franky

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.