vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   how do i restore files from old host to new host? (https://vborg.vbsupport.ru/showthread.php?t=127289)

Chicago_VLNU_4s 09-22-2006 07:20 PM
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 09-22-2006 07:30 PM
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 09-22-2006 07:50 PM
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
Code:
mysqldump -u username -p -h localhost database_name > database_name.sql
Back it up
Code:
tar cvf folder.tar folder_you_want_to_backup
Next move it
Code:
scp folder.tar username@new_host_ip_adress:/path/to/new/web_root
Unpack it
Code:
tar xvf folder.tar
Restore it
Code:
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 09-22-2006 08:46 PM
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 09-22-2006 09:24 PM
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 09-22-2006 10:16 PM
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 09-22-2006 10:18 PM
ok bashy thanks, ill let you know how it goes

Ntfu2 09-23-2006 05:10 AM
Quote:
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 09-23-2006 10:46 PM
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

Quote:
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


All times are GMT. The time now is 02:42 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01013 seconds
  • Memory Usage 1,738KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete