UBB.Developers Forums UBB.threads 7 Development How Do I? If my forum crashed?

My forum crashed, and I cant access teh admin panel to restore. HOw do I get it back online. Do I need to go the phpmyadmin or something, if so. Where and what I need to do?

Exactly what do you mean by "crashed"? That can mean any number of things.

If something has happened to the tables in the database you can repair them with the following:

First write this command at a telnet prompt:

mysql --user=yourusername --password=yourpassword yourdatabasename

Exchange 'yourusername' with the username used to access your database, and 'yourpassword' with the password, and of course 'yourdatabasename' to the name of your threads database.

Then you just repair tables with the following SQL query:

REPAIR TABLE w3t_Posts;

Just exchange w3t_Posts with the names of your crashed tables.

When you are done, you can quit the mysql client by writing 'quit' (without quotes).

like I said, I am new in this. But how do I get into the telnet ?. REmember, My site is being hosted, I am not hosting my own site!.

You'd have to ask your web hosting service about telnet access.

You can also repair tables with phpMyAdmin.

But you still haven't said what you mean by "crashed".

Bascially, I still dont know how is this all connected to each other.

Like what is phpMyAdmin, and how is it connected to threads, and where does MySql comes along. How does the back up work and where does it stores?. etc etc

I would love to know this, just in case in future, my site some how got crashed I would atleast know how to trouble shoot it myself. Anywayone?

The backup and restore function does work on your server in the Threads admin panel. PhpMyAdmin is that one link I sent you via email to access it.

You can do alot of reading at both http://www.phpmyadmin.net and http://www.mysql.com

There are plenty of online documentation to get familiar with each thing and the commands neccesary that are preformed.

phpMyAdmin is a tool to use for modifying your database (mysql). mysql is where all of the information is stored like all of the posts, forums, users, ect... but first we need to know what do you mean by "crashed". What kind of errors are you getting?

His error has been fixed. When some forums were rearranged via the sort forum order a post must have been getting written at the same time. One forum got a bad post pointer written so that forum in a sense dissappeared. This was a silent MYSQL error which did not produce a visible error yet behind the scene's the error's kept getting written to his mysql log on the server. A site that is relatively new which used only 52MB of space ballooned to a whooping 708MB being 58MB overquota which starting shutting everything down and producing errors. Bad part was the error got so bad just touching the log file making it 0 bytes or even RM ing it and then recreating it still was farbing things up. I had to drop MYSQL entirely on the server and reinitialize and recreate the database. Everything was fine and he lost no data.