Can ANYONE please help with a table issue?

[fieroloki]

I had a DB restored about a week or 2 ago and since then I get this error

"Table './fieroloki_IC_20081005_183328/smf_settings' is marked as crashed and last (automatic?) repair failed"


I contacted support once and they were able to get it corrected, but it started happening yesterday, and they told me to re-upload the smf_settings from my end, which i have and same thing.

ANY possible way to save my SMF install and not lose all my users and threads and so on????

[bddotnet]

The save consists in 2 steps:

Step 1: Save the public html files by downloading them to your PC. This can be done with an FTP program.

Step 2: Save the database. This can be done with the "Backup Database" option in the Administration Center of your SMF forum (Admin > Forum Maintenance).

Make sure you save both structure and data of the database as well, either in two different steps or in one unique save.

If you know how to do it, you can also backup your SMF's database with PhpMyAdmin.

[fieroloki]

Everytime I upload the one bad file "smf_settings" it corrupts... I give up... my forum is toast now :(

[Autoload]

What's the delta with the stock smf_settings table and what you have? Judging by the name of the table I'm thinking it contains your forum settings. I shouldn't be too bad to insert a stock table.... no?

[Dbrazzell]

Do you have a copy of the database already somewhere? Maybe a .sql file?

I took a look at this and that database is pretty hosed up. All the standard mysql repair tools are failing on it. I still have a few more tricks up my sleeve to try and get it repaid. However if you have a copy elsewhere I can use. I might be able to get this solved faster.

[Dbrazzell]

Turns out I was able to try a bunch of stuff and get the database repaired.

If you check your site at /forums/index.php you should see that evrey thing is back up and running.

Sorry about the hassle. The database was broken quite badly and support doesn't have the access/training to fix these types of issues. Took me a while and someone from our NOC team to get it fixed.

[fieroloki]

Its working. THANK YOU!! Dbrazzell what caused the issue? I know I messed up up one day be deleting the damn DB, but they restored it and it worked fine a few days, then who knows..I had a back up that kept corupting, and ill make another one now...

[Dbrazzell]

Cant really be sure. I suspect there were some bad rows in the database and they wouldn't make themselves known until your users started posting to the fourms or something else that triggered the issue. Mysql was being touchy as well and wouldn't let anyone run the "REPAIR TABLE" command against the database.

Issue should permanently resolved. PLZ make a backup anyway though. If the issue happens again PM me and I can take a look at it.

[fieroloki]

Backup has been made. Thank you again!!!!