I run MySQL version 4.0.16 on my linux box.
My replication is working fine when I drop my database and import it on the
master server. It seems to me that configuration files for both master and
slave are OK. Privillege too.
I define a user with the following right's:
* Reload
* File
* Super
* Execute
* Replication client
* Replication slave
Now, if want to set up a new slave following these steps:
* Start mysql on the slave
* Run the following command to set up my slave LOAD DATA FROM MASTER;
I get error code 1219 (check privillege).
I specify, I use InnodB scheme for my databases in my master configuration
file. I read that the LOAD MASTER FILE FROM MASTER command support will be
available for Innodb. Is this command available in my version of mysql (
4.0.16)
If yes ,what is going wrong ?
Thanks in advance.
Pierre LUGUERN
IBM Business Consulting Services
Tour Descartes
2 avenue Gambetta - La Défense 5
92066 Paris La Défense
Ext: 01 49 05 55 63 Int: (33) 5563
Fax: 01 49 05 81 18
<mailto:[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
