What is the CORRECT syntax for the mysqladmin command to start the slave thread at a particular position in the log? Here's the situation I ran into. I got an error message in the slave's .err file that said the following: 010125 9:11:16 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'FIRST' position 1544 When I tried to restart the slave according to the syntax in the error, I get the following: mymach2:/usr/local/mysql/var $ mysqladmin start-slave - log 'FIRST' position 1811 Slave started ../bin/mysqladmin: Unknown command: '-' when I looked at the .err file, it said this: 010125 9:32:44 Slave: connected to master 'userrep@mymach1:3306', replication started in log 'FIRST' at position 0 The slave thread did not start at position 1811 as I intended to start it at. Any help is appreciated. Kannan _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
