MySQL Forums
Forum List  »  Replication

Mysql won't start with replication
Posted by: Ruud van Dijk
Date: February 13, 2012 07:51PM

The next piece of code comes out my.cnf:

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
old-passwords
max_connections=500
#max_join_size=25000000
wait_timeout=30
thread_cache_size = 64
key_buffer_size = 512M
query_cache_size = 512M
query_cache_limit = 64M
max_heap_table_size = 512M
key_buffer = 512M
max_allowed_packet = 16M
table_cache = 6144
sort_buffer_size = 64M
join_buffer_size = 750M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 512M
tmp_table_size = 1024M
innodb_buffer_pool_size = 512M

log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db= mydb
server-id=1

long_query_time = 10
log-slow-queries

[mysqldump]


I inserted:
log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db= mydb
server-id=1

I made the directory /var/log/mysql/ so it exists and it's empty.

But when i try to start de mysqld deamon it gives error with starting without an error code
Can someone help me with this problem?

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql won't start with replication
2193
February 13, 2012 07:51PM
720
February 14, 2012 09:57AM
863
February 18, 2012 10:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.