borfast Posted May 24, 2003 Posted May 24, 2003 Hi everyone. I have an IPB webboard installed on a client's account in my reseller account (server 15). A few weeks ago, we had a problem with the database: one of the tables (the file itself) got corrupted and we had to drop the table and create it again. It was no big deal since the table contained only session information, so nothing important was lost. But today it happened again and this time, the Topics table went belly up. As you can imagine, this is not good... Anyway, my question is: is it normal that this happens twice in such a short time? Could it be a problem with the server? And since I'm writing here I take the chance to ask: do you guys make backups of the reseller accounts' databases? I'd like to be able to put the database back without loosing all the data in the table I mentioned. Raul Quote
Lianna Posted May 25, 2003 Posted May 25, 2003 Nightly backups are made, but then overwritten the following night. So, if you don't catch it and get it corrected the same day, the backup isn't going to be much good to you. Please keep in mind that the primary goal of the nightly backups is to restore in case of drive failure, not a goofed or corrupted file/db. That's just an added benefit if caught in time. I can't answer your IPB question except to say that this board is run with it and doesn't experience such problems. Your better resource may be the IPB forums: http://forums.invisionpower.com/ Quote
Head Guru Posted May 25, 2003 Posted May 25, 2003 http://forums.invisionpower.com/index.php?...showtopic=46402 QUOTE mySQL error: Can't open file: '{something}.MYD'. (errno: 145) or QUOTE mySQL error: Can't open file: '{something}.MYI'. (errno: 145) mySQL error code: 1016 (Note: {something} will be different in your error message.) What the error means: Table was marked as crashed and should be repaired Solution: Run the following mySQL query in a program such as phpMyAdmin or eskuel. SQL REPAIR TABLE ibf_blah; Replace "ibf_blah" with the name listed in the error message. Quote
borfast Posted May 26, 2003 Author Posted May 26, 2003 Thanks guys. I figured out the SQL REPAIR TABLE stuff but only after Rick replaced the DB with the one in the backup. Since everything was still the same, I thought that the table was already corrupted at the time of the backup, like Lianna noticed.That's when I thought about goig to phpMyAdmin and play around with the REPAIR/CHECK stuff and voilá! It was all OK Thanks anyway Quote
David Valdes Posted June 10, 2003 Posted June 10, 2003 Problem might be related to cPanel/Apache. There is discussion about it at the Invision forums. Read about it here. Quote
TCH-Rick Posted June 10, 2003 Posted June 10, 2003 It looks like the bug was squashed with the latest upgrades. Haven't seen this problem mentioned lately. Quote
DoubleM Posted June 17, 2003 Posted June 17, 2003 It looks like the bug was squashed with the latest upgrades. Haven't seen this problem mentioned lately. Nope. Just got my very own 1016 error today. I'm running Invision Board 1.1 and one of my tables got corrupted. A simple MySQL repair did the trick, but now I'm debating on how to proceed foward. Apparantly, IBF 1.1 doesn't like SQL 4 all that much and can create errors. I read that IBF 1.2 works better with SQL 4, but it's too early to tell for sure. What are the chances of being able to downgrade our account to SQL 3? Quote
Head Guru Posted June 17, 2003 Posted June 17, 2003 We are no longer downgrading servers to the older version of sql. A upgrade to 1.2 should fix your Table Corruption problems. We are running 1.1.2 here, and have had no problems at all. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.