MySQL replication

Nego

Verified User
Joined
Nov 27, 2008
Messages
18
Hey,

Im trying to create a MySQL replication between 2 servers that are both using Directadmin.

Im using this tutorial to do this:
http://www.howtoforge.com/mysql_database_replication

It seems there are some problems.
1) I cant find a mysql log anywhere. Maybe someone who can tell me something about it?
2) While editing the /etc/my.cnf the MySQL wont start anymore. When starting it i recieve the result (OK - OK) but when looking in directadmin it says: Service stopped.

This is the my.cnf im talking about:

[mysqld]
#skip-networking
#bind-address = 127.0.0.1
log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db=goozup_prod
server-id=1

[client]
socket=/tmp/mysql.sock

Hope someone can help me with this issue
 
Mysql doesnt create logs by default. You can find guides on mysql.org on how to set it up.

Its probably shutting down because it doesnt like something in your config.

So your first step would to enable debug logging then you can find out whats going on.
 
Back
Top