On Thursday 20 July 2006 04:10 am, Dominik Klein wrote: > Hello > > When I re-insert dumped data with "mysql < file.sql", I can simply put > "set foreign_key_checks=0;" at the beginning of the file and this works > fine.
So do it that way > So if there's any other well-known solution for per-table dumpfiles, let > me know. I'm not too keen on writing something myself right now. mysqldump -u [user] -h [host] -p [database] [table] > fixme.sql mysql -u [user] -h [host] -p [database] < fixme.sql and for the paranoid, you can always use the ever efficient test database to test things first: mysql -u [user] -h [host] -p test < fixme.sql > Thanks for your help. > Dominik -- Chris White PHP Programmer/DBlankRounds Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]