My site completely crashed and needs to be restart

[e DoGG 4 sHo]

Hi I am completely lost as to how to go about reloading my server with the site.

I have made frequent mysql backups for my forums through cpanel. And when the server crashed they had to reformat the server in order for it to work, and I have no idea how to get the back ups back onto the server.

[Marco van Herwaarden]

You can find instructions in the vBulletin Manual: Restoring your MySQL Database Manually

[e DoGG 4 sHo]

Thanks for the link.

Upon reading the options available to me, I figured that the database is too large for my upload limit and each time it has timed out. So i need to use the SSH/TelNet solution. I copied below. Where do I get this SSH or Telnet program? Is that any different than the SmartFtp that I already have?

In order to restore your database via SSH or Telnet you will require 2 things:

1) SSH or Telnet access to your site. You will need to check with your hosting company to see if this is available.

2) An SSH/Telnet Client, such as PuTTy.
Note:
If your database backup resides on your home computer, you will first have to upload it via FTP to your website
Open your SSH/Telnet client and log into your website. The command line prompt you will see will vary by OS.
For most hosting companies, this will bring you into the FTP root folder.

Type in the following:

mysql -u dbusername -p databasename < /path/to/backupname.sql

You will be prompted for the database password. Enter it and the database will backup.

If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the servername to the command line. The servername will be the same as in your config.php. The command line will be:

mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql

[bada_bing]

Originally Posted by e DoGG 4 sHo

Thanks for the link.

Upon reading the options available to me, I figured that the database is too large for my upload limit and each time it has timed out. So i need to use the SSH/TelNet solution. I copied below. Where do I get this SSH or Telnet program? Is that any different than the SmartFtp that I already have?

You can use putty for the SSH program.. Do a google search for putty