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.

mysql.ini help needed for slave replication on windows box

Postby 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.
shadlewis
 
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

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

Postby 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
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm

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

Postby 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

Postby 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

Postby 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

Postby 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

Postby 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

Postby 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

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

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

Postby 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
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm

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

Postby 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

Postby 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"
shadlewis
 
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am

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

Postby 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
tgriswold
 
Posts: 120
Joined: Fri Jun 07, 2013 8:52 am

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

Postby 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.
shadlewis
 
Posts: 25
Joined: Tue Oct 04, 2011 3:35 am


Return to Advanced Topics

Who is online

Users browsing this forum: Google [Bot] and 3 guests