"SET FOREIGN_KEY_CHECKS = 0" Suggestion.

[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, this command does not forwarded to Slave.
so, slave fails to insert record.

So my suggestion is "SET FOREIGN_KEY_CHECKS = 0;" forwarded to slave.

What do you think of this?

Have a nice weekend!

##
Heo, Jungsu Mr.
SimpleX Internet. http://www.simplexi.com

Filter : sql



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Error 1236?

[wertyu]

Hello.

I'm using replication both master and slave are MySQL 4.0.10.

But, When I insert many record( ten thousands of record) at a once,
I got follow error message.

###
030219 18:03:20  Error reading packet from server: binlog truncated in the
middle of event (server_errno=1236)
030219 18:03:20  Got fatal error 1236: 'binlog truncated in the middle of event'
from master when reading data from binary log
030219 18:03:20  Slave I/O thread exiting, read up to log 'test42-bin.003',
position 5329913
###

what does this mean? and what shoud I do?

somebody help me~

Replication status after error:

mysql> show slave status \G
*** 1. row ***
  Master_Host: 203.231.xx.xx
  Master_User: repli
  Master_Port: 3306
Connect_retry: 10
  Master_Log_File: test42-bin.003
  Read_Master_Log_Pos: 5329913
   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: 5299624
  Relay_log_space: 5329977
1 row in set (0.00 sec)

mysql> show master status \G
*** 1. row ***
File: test42-bin.003
Position: 5393075
Binlog_do_db:
Binlog_ignore_db: intranet,mysql,repli_test,sfactive,test,traffic,wertyu
1 row in set (0.00 sec)


Thank you for advanced answer!

##
Heo, Jungsu Mr.
SimpleX Internet. http://www.simplexi.com

Filter : sql



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php