Percona system tables corrupted.
Posted
by
Anand Jeyahar
on Server Fault
See other posts from Server Fault
or by Anand Jeyahar
Published on 2011-01-03T09:36:57Z
Indexed on
2011/01/03
9:55 UTC
Read the original article
Hit count: 218
replication
I am having problems setting up mysql replication with a percona as server. accidentally, took a full dump from mysql and restored it on percona and then started,the replication. now when i stop slave and start slave, i am getting the error "[ERROR] Failed to open the relay log './s5-bin.000003' (relay_log_pos 2029993) 110103 9:15:59 [ERROR] Could not find target log during relay log initialization " But show local variables shows the relay_log variable as set in the cnf file..
But the relay-log variable is set to slave-relay-bin alright. I am able to start mysql as a service. But mysqld_safe fails with error "110103 9:19:39 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2) 110103 9:19:39 [ERROR] Can't start server: can't create PID file: No such file or directory "
Am now lost as to what is the problem.
© Server Fault or respective owner