MySQL 5.1 change master syntax issues?
am 16.02.2011 16:15:18 von machielr--=-w61h+AwZpbFXLYuOAjrt
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Hi All
I am trying to setup replication between 2 mysql servers, however
when running the command below on the slave machine, I get the error as
shown below.=20
CHANGE MASTER TO MASTER_HOST=3D'
MASTER_PASSWORD=3D'
master_log_file=âmysql-bin.000620â=99,
master_log_pos=3D713184200;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'â=98
master_user=ârepladminâ=99,
master_password=â
I have confirmed that I am able to connect to the master using
these credentials, however Can't seem to spot my mistake in the command.
The slave server is running mysql-5.1.50 and the master server
is mysql-5.0
Machiel Richards
Relational Database Consulting (Pty) Ltd=20
MYSQL / POSTGRES specialist
20 Stirrup Lane, Woodmead Office Park, Van Reenens Road, Woodmead, South
Africa
Office: 0861 RDC RDC (0861 732 732)
Mobile: +27 72 238 6008=20
Fax: 0861 RDC FAX (0861 732 329)
E-Mail: machielr@rdc.co.za=20
--=-w61h+AwZpbFXLYuOAjrt--