mysql.ini help needed for slave replication on windows box

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

mysql.ini help needed for slave replication on windows box

Post by shadlewis » Wed Nov 11, 2015 11:41 am

In my linux my.cnf file, at the end I have added:

bind-address = 192.168.1.160
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log

What is the windows mycof.ini syntax equivalent?

Thanks.

User avatar
jsalmon
Posts: 1488
Joined: Tue Nov 30, 2010 1:33 pm
Contact:

Re: mysql.ini help needed for slave replication on windows b

Post by jsalmon » Wed Nov 11, 2015 12:29 pm

I don't believe my.ini and my.cnf syntax differ via OS (unless you are referring to the path to the log file). What dictates the syntax for the MySQL config file is the version of MySQL is installed. What version do you have?

If you don't know, you can always run this query (assuming you can get your MySQL service started):

Code: Select all

SHOW VARIABLES LIKE "%version%";
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Wed Nov 11, 2015 12:57 pm

5.5

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Wed Nov 11, 2015 1:08 pm

Code: Select all


mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 1.1.8                        |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.5.14                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86                          |
| version_compile_os      | Win32                        |
+-------------------------+------------------------------+
7 rows in set (0.02 sec)

mysql>

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Wed Nov 11, 2015 1:19 pm

This does not work:

Code: Select all

[mysqld]
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
datadir="C:/mysql/data/"
default-storage-engine=MyISAM
max_allowed_packet=40M

bind-address = 192.168.1.160

server-id = 2

log-bin = C:\mysql\mysql-bin.log

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Wed Nov 11, 2015 1:21 pm

Image

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Wed Nov 11, 2015 1:22 pm

It did add these, though...

Image

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Wed Nov 11, 2015 1:26 pm

And the service status on the server...

Code: Select all

[info] /usr/bin/mysqladmin  Ver 8.42 Distrib 5.5.46, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version          5.5.46-0+deb7u1-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 2 hours 12 min 35 sec

Threads: 9  Questions: 55954  Slow queries: 0  Opens: 3748  Flush tables: 1  Open tables: 400  Queries per second avg: 7.033.
@odserver:~$ [info] /usr/bin/mysqladmin  Ver 8.42 Distrib 5.5.46, for debian-linux-gnu on x86_64-bash: [info]: command not found
@odserver:~$ Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Uptime:                 2 hours 12 mi-bash: syntax error near unexpected token `c'
n 35 sec


User avatar
jsalmon
Posts: 1488
Joined: Tue Nov 30, 2010 1:33 pm
Contact:

Re: mysql.ini help needed for slave replication on windows b

Post by jsalmon » Wed Nov 11, 2015 4:01 pm

shadlewis wrote:This does not work:

Code: Select all

[mysqld]
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
datadir="C:/mysql/data/"
default-storage-engine=MyISAM
max_allowed_packet=40M

bind-address = 192.168.1.160

server-id = 2

log-bin = C:\mysql\mysql-bin.log
I don't have time today to look at this closely but it might be as simple as your slashes are going the wrong way in your log-bin setting.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Wed Nov 11, 2015 6:55 pm

LOL. It will be the first thing I do when I get in.

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Thu Nov 12, 2015 8:43 am

This is what I have now, and it is not working...

Code: Select all

[mysqld]
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
datadir="C:/mysql/data/"
default-storage-engine=MyISAM
max_allowed_packet=40M

bind-address=192.168.1.160

server-id=2

log-bin="C:/mysql/mysql-bin.log"

tgriswold
Posts: 122
Joined: Fri Jun 07, 2013 8:52 am

Re: mysql.ini help needed for slave replication on windows b

Post by tgriswold » Thu Nov 12, 2015 3:28 pm

Have you checked out http://www.opendental.com/manual/replication.html? It has instructions for both one way replication and daisy chain, which have a few more options mentioned in their .ini settings than you currently have.
Travis Griswold
Open Dental Software
http://www.opendental.com

shadlewis
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

Re: mysql.ini help needed for slave replication on windows b

Post by shadlewis » Fri Nov 13, 2015 5:25 am

I saw that, but I hope to not lose the workstation that I'm putting the slave on. I want to use the mysql server independently of the software. That's why I'm trying to do it outside of OD.

Post Reply