1st time site is down, need guidance!

[kimmer]

Ok, can someone give me an idea of what is wrong with my site. Go to www.s197forum.com and click forum. Gives me a database error, but this is the first time i've had a problem and need some help figuring out what to do. This is my first forum i've ever done. Please help, its been down for a couple days while i've been on vacation and I just found out.

[steven s]

Unless you changed something in your config file, have you checked with your host?

[kimmer]

Just email the host, godaddy. Hopefully they can help. Does anyone know of a good quality host for forums that will become large and support alot of connections with a reasonable price?

[Steve Machol]

For future reference, right-click on the error page and go to View/Source. That will show the real database error message:

MySQL Error : Unknown database 's197vb'

Your database is missing. Assuming you have the correct db name in your config.php file, this is something you will need to ask GoDaddy about.

[kimmer]

Dang, looks like the database is messed up. Is there a way to install on a new database, then install a backup file to get back some of the info? Never done this, so sorry for any dumb questions.

[Steve Machol]

If you have a backup of the database you could restore that. Otherswise you will have to hope your host can find it.

The only reliable method of restoring a database is with shell access via telnet or ssh. This is because restoring with a PHP script like that in phpMyAdmin can result in PHP timeout errors and an incomplete database. Please see the instructions here:

http://www.vbulletin.com/docs/html/maintenance_ssh_restore

Note: Some people have reported success with these scripts:

MySQLDumper:

http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:

http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump (restore only):

http://www.ozerov.de/bigdump.php

[kimmer]

I have a quick question, in the bigdump setup, it asks this, but being new to this, i'm not sure what it is asking for or where I find this setting.

$csv_insert_table = ''; // Destination table for CSV files

[Steve Machol]

Sorry, I don't have any experience with bigdump. I suggest checking their website for instructions.

[kimmer]

Guess I have to hope godaddy can find it. I messed around with each way and just couldn't get anything to work. I tried the ssh/telnet but couldn't get it to connect. Not sure if I was using the wrong info or godaddy just didn't support it.

[bhanuprasad1981]

yeh go daddy doesnt support telnet or ssh on shared hosting

[steven s]

I have a quick question, in the bigdump setup, it asks this, but being new to this, i'm not sure what it is asking for or where I find this setting.

$csv_insert_table = ''; // Destination table for CSV files

Maybe I have an old version, but I don't have that line in my copy.
Unless you have a good backup of your database, bigdump won't do anything for you. Bigdump breaks up the sql file in bite-sized chunks, overwise you hit limits. But if your sql file is small, it doesn't matter.

There are many, many good hosts.
I'll PM you who I use.