On Wed, Mar 11, 2009 at 4:03 PM, Bryan Irvine <sparcta...@gmail.com> wrote: > > I've got 2 questions about my newly set up master->slave replica. > > 1> When I run "load data from master;" I get an error that I do not > have RELOAD privileges and then it boots the slave offline. > I've run GRANT SELECT, PROCESS, FILE, SUPER, REPLICATION CLIENT, > REPLICATION SLAVE, RELOAD ON *.* TO root@'%' IDENTIFIED BY 'password'; > flush privileges; > > but it still does the same thing. > > > 2> Is there a way to get a slave to automatically re-connect as the > slave without having to know the masters binlog and position? Each > time it reboots I have to manually add it back in with the change > master to ... command. > > TIA > > -Bryan
#1. "This feature is deprecated. We recommend not using it anymore. It is subject to removal in a future version of MySQL." #2. Replication info should be being recorded on the master.info in your data dir. -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org