thanks - i had to reset the whole db and the error went away - do not know what i did wrong. thanks
On Tue, Jun 5, 2012 at 3:35 PM, Andrew Moore <eroomy...@gmail.com> wrote: > Joey, please consult your mysql error log. Something has gone wrong on your > server where innodb is not started. > > On Tue, Jun 5, 2012 at 3:53 PM, Joey L <mjh2...@gmail.com> wrote: >> >> I am following or trying to follow this document: >> http://www.howtoforge.com/mysql5_master_master_replication_debian_etch >> >> I think it is running in a good state because when i query the show >> slave state, I get awaiting connection from host, like : >> >> on server1: >> >> mysql> SHOW MASTER STATUS; >> +------------------+----------+--------------+------------------+ >> | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | >> +------------------+----------+--------------+------------------+ >> | mysql-bin.000035 | 106 | mailserver | | >> +------------------+----------+--------------+------------------+ >> 1 row in set (0.00 sec) >> >> mysql> show slave status\G; >> *************************** 1. row *************************** >> Slave_IO_State: Waiting for master to send event >> Master_Host: 192.168.2.121 >> Master_User: slave1_user >> Master_Port: 3306 >> Connect_Retry: 60 >> Master_Log_File: mysql-bin.000024 >> Read_Master_Log_Pos: 106 >> Relay_Log_File: relay-bin.000025 >> Relay_Log_Pos: 251 >> Relay_Master_Log_File: mysql-bin.000024 >> Slave_IO_Running: Yes >> Slave_SQL_Running: Yes >> Replicate_Do_DB: mailserver >> Replicate_Ignore_DB: >> Replicate_Do_Table: >> Replicate_Ignore_Table: >> Replicate_Wild_Do_Table: >> Replicate_Wild_Ignore_Table: >> Last_Errno: 0 >> Last_Error: >> Skip_Counter: 0 >> Exec_Master_Log_Pos: 106 >> Relay_Log_Space: 545 >> 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: 0 >> Master_SSL_Verify_Server_Cert: No >> Last_IO_Errno: 0 >> Last_IO_Error: >> Last_SQL_Errno: 0 >> Last_SQL_Error: >> 1 row in set (0.00 sec) >> >> ERROR: >> No query specified >> >> >> On Server2: >> >> mysql> show master status ; >> +------------------+----------+--------------+------------------+ >> | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | >> +------------------+----------+--------------+------------------+ >> | mysql-bin.000024 | 106 | mailserver | | >> +------------------+----------+--------------+------------------+ >> 1 row in set (0.00 sec) >> >> mysql> show slave status\G; >> *************************** 1. row *************************** >> Slave_IO_State: >> Master_Host: 192.168.2.121 >> Master_User: slave2_user >> Master_Port: 3306 >> Connect_Retry: 60 >> Master_Log_File: >> Read_Master_Log_Pos: 4 >> Relay_Log_File: relay-bin.000001 >> Relay_Log_Pos: 4 >> Relay_Master_Log_File: >> Slave_IO_Running: No >> Slave_SQL_Running: No >> Replicate_Do_DB: exampledb,mailserver >> Replicate_Ignore_DB: >> Replicate_Do_Table: >> Replicate_Ignore_Table: >> Replicate_Wild_Do_Table: >> Replicate_Wild_Ignore_Table: >> Last_Errno: 0 >> Last_Error: >> Skip_Counter: 0 >> Exec_Master_Log_Pos: 0 >> Relay_Log_Space: 125 >> 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 >> Master_SSL_Verify_Server_Cert: No >> Last_IO_Errno: 0 >> Last_IO_Error: >> Last_SQL_Errno: 0 >> Last_SQL_Error: >> 1 row in set (0.00 sec) >> >> ERROR: >> No query specified >> >> On server1 - I am able to do a select statement to the table and get >> back results. >> On server2 - i get the error regarding no innodb.below: >> >> >> >> ERROR 1286 (42000): Unknown table engine 'InnoDB' >> mysql> select * from virtual_users ; >> ERROR 1286 (42000): Unknown table engine 'InnoDB' >> >> >> can anyone assist ? >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql