[Mosh]

Originally Posted by clearchannel

I have installed and it works great clicks install.

One question. If I compress my database during backup, what is the syntax I use to restore the database?

excample: mysql -uusername -p databasename </home/virtual/site1/fst/var/www/html/forums/backups/databasename.sql.gz

Firstly you need to run gzip to uncompress the archive:

gzip -d /home/virtual/site1/fst/var/www/html/forums/backups/databasename.sql.gz

Then run:

mysql -uusername -ppassword databasename < /home/virtual/site1/fst/var/www/html/forums/backups/databasename.sql

ADDITION: When you refresh the forum, you may have to login to the admincp, if you choose to turn them off when the backup was being performed:

goto vBulletin Options -> vBulletin Options -> Turn Your vBulletin On and Off -> Forum Active. Ensure the Yes radio button is selected and click Save (yes even if it was already selected the saving of it will re-enable the forums).