Transfer

I really need help transfering hosts. I tried 3 times but dosnt work... If anyone could help me that be great... I have a backup from the admin control panel and also i FTP'd all my forum files onto my server. So next in Cpanel i go to backup and restore the database. I get allllll these errors. Could anyone care to help me? thanks 100 if you do. im so depressed.

[gulldarek]

Why don't you make mysqldump via SSH? That would be a lot faster and secure, also you wouldn't have to export anything from ACP.

[oninuva]

wats SSH

i dun know anyof these things.

[gulldarek]

If you've cpanel then ssh too. Assuming that you're MS Windows user, download PuTTY from here: http://the.earth.li/~sgtatham/putty/.../x86/putty.exe . Run it, enter your servers ip and port, click "Open". You'll be asked for login and password (login as root if you can). Then you've to change dir to your public_html (probably /home/_login_/public_html/. _login_ is your account name. From there run this command:

mysqldump --opt -Q -u dbusername -p databasename > backup.sql

dbusername is a login to your database and databasename is a name od the db ;-). you'll be asked for password, enter it and wait until you see a cursor which means that the data from db was dumped to specified file (backup.sql). Now, point your browser to http://www.yourwebsite.com/backup.sql and download it OR if you've shell access on your new server connect to it and use wget to download dumped data. Tell me if you need some live help, I can help you.

[oninuva]

i need live help because my old host killed my site already. I cant make any new backups all i got is my um... old one? from teh acp. Do you have MSN or Yahoo?

[gulldarek]

I don't think you can make user table backup via ACP... What exactly did you exported?

And no, I've no MSN.

[calorie]

Thread moved to General Hosting/Server Discussions. Please do not start multiple threads about the same issue. Thanks.

[oninuva]

o i thought you delted my thread sorry

Your best bet at your skill level is to email your host.

Upload your files back into the proper structure with FTP, I'm sure you know how to do that. Then upload your database dump to any old folder.

Create your new database, and email your host with the database name, dbusername and password, and ask them if they'll help you out by importing the dump that you've uploaded. It will take a competent tech about 30 seconds to do via shell instead of you trying to manually import it using something like MySQLAdmin.

Otherwise, have a look here:

http://www.vbulletin.com/docs/html/m...yadmin_restore

And here:

http://www.vbulletin.com/docs/html/m...tabase_restore

Once they've imported your database into the new one, all you'll need to do is edit your config.php to reflect the path change and new database name/password.

It's a very basic customer service request and honestly if they won't take a moment to do it for a paying customer, you should look for a new host.

[Mastar]

I restored it for him