how do i restore files from old host to new host?

i just recently (30 mins ago) bought a new host due to my current host closing down shop. So i want to backup my public_html folder and switch it to the new host. But how do i do this? I'm clueless when it comes to this server crap!

[bashy]

The only way i know is to download the public_html folder to your computer using your ftp program, then reupload to your new server...

[Ntfu2]

Do you have SSH access? If not try getting it. If you cant get it. you'll have to do as bashy said,

Dump It

mysqldump -u username -p -h localhost database_name > database_name.sql

Back it up

tar cvf folder.tar folder_you_want_to_backup

Next move it

scp folder.tar username@new_host_ip_adress:/path/to/new/web_root

Unpack it

tar xvf folder.tar

Restore it

mysql -u username -p -h localhost database_name < database_name.sql

Sure that may look confusing or hard, but its simple as can be, and if you need help, let me know i'll move it for free for you without a problem

[bashy]

Damn, i thought ya could do it using SSH but i dont think i will ever bother lol
I just leave mine to download for a day or so, then upload for 2 days or so lol

Using SSH could you transfer from server to server? is that what im seeing in your example?

I spose that would pretty darn quick?

[Chicago_VLNU_4s]

well i came to figure, i could just save the public_html folder and upload the files that are in this one to the new host public_html folder and it will work, right?

[bashy]

Yes you are 100% correct, although, there may need ot be a little configuring.
See how you get on 1st, if theres any errors when completed post here the errors and will take it from there!

[Chicago_VLNU_4s]

ok bashy thanks, ill let you know how it goes

[Ntfu2]

Originally Posted by bashy

Damn, i thought ya could do it using SSH but i dont think i will ever bother lol
I just leave mine to download for a day or so, then upload for 2 days or so lol

Using SSH could you transfer from server to server? is that what im seeing in your example?

I spose that would pretty darn quick?

Yes, I transfered roughly 20+gb the other day from one server to the next in about 30 minutes or so i think it was.

That was on a 100mbps, sure beats waiting days for downloads, and more days to reupload

[Chicago_VLNU_4s]

well, i put all my files on the new host, and ran the install process of my new board. It's basically completley new. I looked in phpMyAdmin and there were no tables b4 i installed. So i made a backup of my board maybe 2 days ago (thank God). I'm attempting to restore my tables and everything else. So i goto:

phpMyAdmin > Import > Browse File

select my "vbulletin.sql" then character set of file "utf8" correct? This will complelety restore everything? If not, tell me what i do? I have my vbulletin.sql file updated, so what do i gotta do to restore everything


THANKS!

nevermind... i did just that and it worked! I'm back up baby!


*****************************

i looked at it when it was done, and here's what it says

Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNodjsFOg0AARO/7FXNogiawXRYCZD0RsqkkFCpL8WioVCVBQKDa/hX/Q/wXwbnO5L2RaZqkAoGJ
gCOSsYDlwvJg20RlSzEREuRKYBOWAsNX3RX9cO5pXZ1o99Hp3+ DUdsEZc7bM3JouTFcwLiyG19up
HV/GT8hrhw3Z39RTJGBTk3LTGMaiKYu+NOr2nRxVikTp8HcyznTkc vE+Vw1CCYcyctj7YtF4lFFO
Do+HdaAnamXZdDldNZcrifx4J3BujMv4Znjk30XCWMk0QxhnCX 7avkTuR0ep7jTbcZimQ5vXTNM0
T/P8q90//AHNbE19
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 37 38 44
STR: ?

CVS: $Id: sqlparser.lib.php,v 2.47 2006/01/17 17:02:30 cybot_tm Exp $
MySQL: 4.1.21-standard-log
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.8.0.2
PHP VER,OS: 4.4.2 Linux
LANG: en-utf-8
SQL:
INSERT INTO word VALUES('4660', 'ۛۛ۰??۰ۛݧ);
----END RAW----


SQL query:

INSERT INTO word VALUES('4660', 'ۛۛ۰??۰ۛݧ);

MySQL said:

#1062 - Duplicate entry '??????????' for key 2