mysql.ini help needed for slave replication on windows box

[shadlewis]

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.

[jsalmon]

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%";

[shadlewis]

5.5

[shadlewis]

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]

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]

[shadlewis]

It did add these, though...

[shadlewis]

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

[jsalmon]

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.

[shadlewis]

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

[shadlewis]

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]

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.

[shadlewis]

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.