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
