Didn't have the list cc-ed..... -----Forwarded Message----- > From: Andrew Hall <[EMAIL PROTECTED]> > To: Mike Johnson <[EMAIL PROTECTED]> > Subject: RE: replication question > Date: Fri, 05 Dec 2003 16:17:14 -0500 > > Ok, at this point it appears my replication is working, but I have two > questions: > > 1. I tested by creating a table on the master, populated it, then on the > slave did a 'show tables', and 'select * from test', and my test table > and data was there. Is this methodology acceptable for a basic test? > Any suggestions on testing methodology? > > 2. When I execute 'show master status' the Binlog_db_do fields is > empty. This seems erroneous to me. Shouldn't this field be populated > with the db name(s) to replicate? > > Thanks again, > > Drew > > > execute > > > 'START SLAVE' > > > on my slave I get > > > > > > ERROR 1064: You have an error in your SQL syntax near 'START SLAVE' at > > > line 1 > > > > > > This tells me that my version of mysql does not support the 'START' > > > command. Do I need to add something at compile time? Are the > > > instructions only for 4.x? Am I just missing something > > > really obvious? > > > > > > Don't quote me on it, but I think START SLAVE was introduced in 4.x. Try SLAVE > > START. I recently read that SLAVE START was being deprecated; I can only assume > > START SLAVE was a recent introduction. > > > > Regardless, I always used SLAVE START on 3.23.x. > > > > HTH > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
