Re: replication, table db already exists

[Gleb Paharenko]

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





jabbott@stripped 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
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com