Yes, that's probably best. I have no idea what the state of the data on the slave is now really. After skipping about 10 corrupted bits of logs,...
Using this guide to step over corrupted logs, it appears to be slowly working:...
I found a thread about removing the ib_logfiles. I backed these up and tried this. This brings the server online, but I'm not sure yet if it's...
So I was forced to upgrade the slave server. Unfortunately, this broke my replication. I'm not sure how to get this going again without starting...
I ended up dropping the slave's db and reimporting the dump file. It worked this time. I'm not sure what changed since the first attempt as I...
I copied over the .frm files from the master to the slave, but it's still failing saying they have incorrect information. The file it's...
Ack, it looks like this is my problem, missing a major step for innodb: http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html
I can't seem to get the slave to start with innodb; those errors kill it. Here's the my.cnf on the slave: http://pastie.org/657206
Okay, so it now connects fine, but I get some errors. The filenames and position numbers look correct: This sounds like an innodb issue......
Edit: nevermind, I'm an idiot... apparently iptables WAS running :(
I can ssh from each box to the other. I'm not sure why mysql won't connect. Any ideas?
I've followed the howto; have the db imported into the slave, but I'm having trouble getting the slave to connect to the master. I don't have...
I setup the master with those additional innodb settings. My data files now look something like this: 4.0K mysql-bin.000001 4.0K...
I just noticed these comments on the howto; I'm running InnoDB, is this correct?
Actually, nevermind. I'm just going to setup another machine as the slave. The first problem I encountered was this: /usr/libexec/mysqld: File...
Separate names with a comma.
