Hello.
Did you set the master_log_pos and master_log_file to the correct value? Did you use --master-data option for mysqldump as mentioned at: http://dev.mysql.com/doc/mysql/en/replication-howto.html [EMAIL PROTECTED] wrote: > > Hello All, > Here is a problem I have been trying to debug for a few days. I had a mysql > server running for about a month. I did a mysql dump of all the tables on > the master and setup a second machine to be the slave, loading all the > tables. I set the replication stuff up in the slave my.cnf. Now as soon as > I start the slave I get good data flow between the two machines but the slave > does not update with the error below. Is this because I did not do a binary > snapshot of the master machine to setup the slave? I originally was not > going to setup replication, just going to do dumps of tables, but then > changed directions. > > Thanks! If you need more info, please ask. > > --ja> > mysql> show slave status \G; > *************************** 1. row *************************** > Slave_IO_State: Waiting for master to send event > Master_Host: 192.168.1.100 > Master_User: repster > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: rhea-bin.000017 > Read_Master_Log_Pos: 405948310 > Relay_Log_File: dione-relay-bin.000002 > Relay_Log_Pos: 121 > Relay_Master_Log_File: rhea-bin.000001 > 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: 1050 > Last_Error: Error 'Table 'db' already exists' on query. > Default database: 'mysql'. Query: ' CREATE TABLE db ( Host char(60) binary > DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User > char(16) binary DEFAULT '' NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' > NOT NULL, Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv > enum('N','Y') DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') DEFAULT 'N' > NOT NULL, Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv > enum('N','Y') DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') DEFAULT 'N' > NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT NULL, Index_priv > enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') DEFAULT 'N' > NOT NULL, Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL, > Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL, PRIMARY KEY Host > (Host,Db,User), KEY User (User) ) comment='Database privileges'' > Skip_Counter: 0 > Exec_Master_Log_Pos: 79 > Relay_Log_Space: 11454541057 > 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: 12172794 > 1 row in set (0.00 sec) > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
