MySQL my.ini editting error!

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL my.ini editting error!

Postby grestin » 09. March 2014 08:26

I just got XAMPP today. When I edited, for example
# The port the master is listening on.
# optional - defaults to 3306
master-port = 3306


ORIGINAL WAS:
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>

I got a log error, saying the code was nil. Any help?
grestin
 
Posts: 6
Joined: 09. March 2014 08:24
Operating System: Windows 7

Re: MySQL my.ini editting error!

Postby grestin » 09. March 2014 16:10

2014-03-09 11:10:52 2140 [ERROR] c:\xampp\mysql\bin\mysqld.exe: unknown variable 'master-port=3306'
grestin
 
Posts: 6
Joined: 09. March 2014 08:24
Operating System: Windows 7

Re: MySQL my.ini editting error!

Postby JJ_Tagy » 09. March 2014 21:32

Are you replicating a slave or just trying to change the MySQL port? If the latter, you are editing the wrong section. If the former, you need to change more than just that one line. That and 3306 is default anyways.
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: MySQL my.ini editting error!

Postby grestin » 10. March 2014 01:24

Another example, when I change the host on it. I get what you mean, but is it the same processes for changing the host IP?
grestin
 
Posts: 6
Joined: 09. March 2014 08:24
Operating System: Windows 7

Re: MySQL my.ini editting error!

Postby grestin » 10. March 2014 01:27

And what else do I need to change besides that one line?
grestin
 
Posts: 6
Joined: 09. March 2014 08:24
Operating System: Windows 7

Re: MySQL my.ini editting error!

Postby JJ_Tagy » 10. March 2014 03:55

That all depends on what you are trying to do - as asked above.
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: MySQL my.ini editting error!

Postby grestin » 14. March 2014 21:48

I'm trying to replicate the slave.
grestin
 
Posts: 6
Joined: 09. March 2014 08:24
Operating System: Windows 7

Re: MySQL my.ini editting error!

Postby JJ_Tagy » 14. March 2014 23:36

A lot of information/instructions on replication: http://dev.mysql.com/doc/refman/5.6/en/replication.html
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: MySQL my.ini editting error!

Postby grestin » 16. March 2014 02:25

I got a tutorial
When I set the MASTER-HOST to the IP, I got this:
2014-03-15 21:26:02 2040 [ERROR] c:\xampp\mysql\bin\mysqld.exe: unknown variable 'master-host=00.00.00.00'

(I replaced it with 0s cause I dont want my IP out there)
Then it proceeded to abort.
grestin
 
Posts: 6
Joined: 09. March 2014 08:24
Operating System: Windows 7

Re: MySQL my.ini editting error!

Postby JJ_Tagy » 16. March 2014 04:29

Looks like as of MySQL 5.5, they removed the config options. In order to set up replication, you should follow the current instructions.

http://dev.mysql.com/doc/refman/5.5/en/ ... slave.html
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 101 guests