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: 191

Filed under:

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

Related posts about replication