SET FOREIGN_KEY_CHECKS = 0 Suggestion.

2003-02-21 Thread wertyu
Hello, everyone. I'm using MySQL replication(Version 4.0.10) Master and slave have FOREIGN KEY constration. and I back up data with mysqldump. but mysqldump does not produce table and record invalid order for FK. So,when I restore data, I execute SET FOREIGN_KEY_CHECKS = 0; on master. But,

Error 1236?

2003-02-19 Thread wertyu
Relay_Log_File: wertyu-relay-bin.002 Relay_Log_Pos: 5329973 Relay_Master_Log_File: test42-bin.003 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: mysql Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos