On Thu, May 22, 2008 at 10:41 AM, François Beausoleil <[EMAIL PROTECTED]> wrote:
> 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. > If your taking a dump of the master open two windows. Don't close either In the first lock all tables with FLUSH ALL TABLES WITH READ LOCK; & master status; Then in the second window procedure with mysqldump. > > 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 This is a Duplicate primary key. Usually means the position error. > > 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] > >