Hi all!
I must be stupid or something. I can't find what my problem is.
I searched this list, and did find a couple of hits, but nothing that
seemed fully relevant. This one in particular was interesting: http://lists.mysql.com/mysql/212863
I have a single master (server-id=1) and a single slave (server-id=2).
Replication was correctly setup, and I was doing backups from the
slave. To test recovery, I terminated the slave server (I'm on EC2),
and I now wish to start a new one.
First, I dump my master using this:
mysqldump --master-data --flush-logs --extended-insert --single-
transaction -u root -papassword mydb >thedump.sql
Then, I copy the dump to the slave and load the dump using:
mysql -u root -papassword mydb <thedump.sql
Next, I login to the slave server using the mysql command line client
and issue the following commands:
CHANGE MASTER TO MASTER_HOST='10.252.155.80',
MASTER_USER='root',
MASTER_PASSWORD='apassword',
MASTER_LOG_FILE='mysql-bin.000054',
MASTER_LOG_POS=98;
I read the log file and position from the dump (--master-data),
specifically, this line:
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000054', MASTER_LOG_POS=98;
Then, I issue a START SLAVE on the slave, and SHOW SLAVE STATUS\G
Here's the output:
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.252.155.80
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000054
Read_Master_Log_Pos: 39727978
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 1381
Relay_Master_Log_File: mysql-bin.000054
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1062
Last_Error: Error 'Duplicate entry '479084' for key
1' on query. Default database: 'mydb'. Query: 'INSERT INTO assets
(`content_type`, `email_id`, `size`, `thumbnail`, `updated_at`,
`account_id`, `archive_id`, `title`, `type`, `folder_id`,
`description`, `filename`, `height`, `owner_id`, `parent_id`,
`created_at`, `width`) VALUES('image/jpeg', NULL, 6571, 'small',
'2008-05-21 23:24:10', 125, NULL, NULL, NULL, NULL, NULL,
'0101100102000104022008052003d78e21fe087d9623000b5c-21_small.jpg',
180, NULL, 479082, '2008-05-21 23:24:10', 240)'
Skip_Counter: 0
Exec_Master_Log_Pos: 1244
Relay_Log_Space: 39728115
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Anybody can tell me what I'm doing wrong ? Am I dumping my master DB
using the right combination of options ?
Thanks !
François Beausoleil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]