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:
Hope someone can help me with this issue
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