Greetings, I am having a difficult time understanding my replication error. I have two mysql installs both 3.23.54. I executed the following for my replication setup.
On master: - stop mysql - add the following to my.cnf: [mysqld] log-bin server-id=1 - tar up data dir, copy to slave - start db - show master status; On slave: - stop mysql - add the following to my.cnf [mysqld] server-id=2 - untar data file - start db - connect, change master to..... - slave start; At this point I get: 031208 18:10:24 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'xxxxxx-bin.001' at position 73 And it appears that its working, but if I attempt to use the db I get: Didn't find any fields in table 'blah' 031208 18:15:16 InnoDB error: Cannot find table db/blah from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? Look from section 15.1 of http://www.innodb.com/ibman.html how you can resolve the problem. And if I try to select I get the same error as above plus: ERROR 1016: Can't open file: 'blah.InnoDB'. (errno: 1) But my master does not have any files name *.InnoDB in it's data dir, so why does the master believe the table is of the InnoDB type? Could someone please shed some light on what I have done wrong here. Thank you in advance, Andrew Hall -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
