moving vbulletin to hostgator

[Booyakan]

I have a vbulletin forum i want to move from ipower to hostgator. I have downloaded the site and database backups.

I want to move the forum to an addon domain. can someone please tell me where to upload the the tar.gz files? I am a bit confused as it sais "Restore a Home Directory Backup " I didn't want to accidentally erase everything I have..

[abu1958]

I think hostgator can move your site ask them

http://forums.hostgator.com/ for members support...

https://tickets.hostgator.com/ if you want direct and quick support

[Booyakan]

I am past the 30 day rule and they wanted 30$ per half hour... All I really need to know is how to move the database. It is in tar.gz format.

The database files that are downloaded when backed up from hostgator appear to be sql.gz. I tried to restore my database but it did not work correctly. anyone know how to d o this?

[SEOvB]

to restore sql.gz files

gunzip < databasename.sql.gz | mysql -u username -p target_databasename

To unpack the tar.gz

tar zxvf filename.tar.gz

If you need to move files use

scp filename loginname@SERVERIP:/home/path/to/your/account

These commands will need to be ran from shell/SSH

[Booyakan]

Ok. I found how to export the database as the same file format through phpmyadmin from my old host, now my problem is this...

the database name is "xxxx_forums"
the name gets changed to "newusername_xxxxforums" when uploading the backup.
So.. I guess I am asking now, how do I change the name of the mysql database in phpmyadmin. I have googled and looked through pages and pages but have found nothing..(hard to believe)

[snakes1100]

The db name means nothing, even tho the old db had a different name, when importing the backup sql file, your just importing the data & structure, not the name of the db.

Just change your config.php to reflect the new db name & user info if thats changed as well

[Booyakan]

got it....thanks everyone...