vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Team: Hot or Not? Ready for Traffic Explosion? vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! vBSEO Helps Forum Earn $100/day from Google AdSense Discover the Power of "Long Tail Search" Crawlability Inc. Files for SEO Technology Patent
se sw

Is it possible to do a seamless move of servers?

This is a discussion on Is it possible to do a seamless move of servers? within the General Discussion forums, part of the vBulletin SEO Discussion category; I have my new server almost set up as I want it, and the old server is still the one ...

Go Back   vBulletin SEO Forums > vBulletin SEO Discussion > General Discussion

Enhancing 80 million pages.

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 05-11-2008, 11:35 PM
Member
 
Real Name: Dave
Join Date: Oct 2007
Posts: 61
Is it possible to do a seamless move of servers?

I have my new server almost set up as I want it, and the old server is still the one using the domain name.

Is there a trick to doing a relatively seamless changeover of the domain from one server to the other?

I installed VBSEO on my new server, and then installed my saved settings from the old server, and I noticed that all the links pointed back to the old server where the domain name still is.

Could I, in theory, use VBSEO to do the seamless (ish) changeover?

Does this make sense?

Thanks.

Dave.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 05-12-2008, 12:10 AM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
 
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 4,496
having moved servers several times, i beleive this is the best way.

1) set up the new server so it's ready to go (no sites yet.. but php, etc all ready)
2) add to sql access hosts on the new box, the old box ip
3) close forum, make final DB backup and file back up
4) perform the move of sites with cpanel, or whatever you are using
5) login to OLD box (use IP, not .com to make sure you are in the right place), set DB in config to point to IP of the new server instead of localhost
6) turn on OLD forum
7) turn on new forum
8) change DNS/name servers for your domains
9) two days later, after dns has surely propigated everywhere, bulk copy attachments/gallery pics/etc with changed dates newer than your move date/time to the new box so in case someone did an upload via old dns, its on the new box too. you might want to do this a couple times if time permits. shouldn't be but a handful of files, unless your site is attachment heavy.

This way, BOTH file systems will hit one (the new) database. you won't lose any database posts etc during the transfer regardless of which server the user happens to hit.. and with the manual attachment move, your new server will be 100% with only 30 min or so of close time due to backups/moving.

vbseo is seem less in the process, unless you are changing .com's as well
__________________
My Blog | Available for paid mods/addons. PM me your RFP.

My Free Mods/Articles: Easy Thread Prefixes for the 50-states | Who Tagged? | New Users with no Visitor Messages

the Ultimate Guide to vBSEO
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 05-12-2008, 11:09 AM
Member
 
Real Name: Dave
Join Date: Oct 2007
Posts: 61
Quote:
Originally Posted by briansol View Post

1) set up the new server so it's ready to go (no sites yet.. but php, etc all ready)
2) add to sql access hosts on the new box, the old box ip
3) close forum, make final DB backup and file back up
4) perform the move of sites with cpanel, or whatever you are using
5) login to OLD box (use IP, not .com to make sure you are in the right place), set DB in config to point to IP of the new server instead of localhost
6) turn on OLD forum
7) turn on new forum
8) change DNS/name servers for your domains
9) two days later, after dns has surely propigated everywhere, bulk copy attachments/gallery pics/etc with changed dates newer than your move date/time to the new box so in case someone did an upload via old dns, its on the new box too. you might want to do this a couple times if time permits. shouldn't be but a handful of files, unless your site is attachment heavy.

This way, BOTH file systems will hit one (the new) database. you won't lose any database posts etc during the transfer regardless of which server the user happens to hit.. and with the manual attachment move, your new server will be 100% with only 30 min or so of close time due to backups/moving.

vbseo is seem less in the process, unless you are changing .com's as well
Hi Brian,

Great post, thanks for that

I have a couple of problems though.

I have no ssh on the old server (shared hosting), but do on the new server, so I used mysqldumper to load up the old database (3.6.8) into the new install of VB 3.7.0.

Obviously, a lot of things were out of date, so I have spent the last few days fixing it all, redoing my custom templates, re-adding the add-ons/template edits and so on.

I was under the impression that I could simply back up the last few days posts on the old server and then merge them with the new database. It all goes wrong at this point, database errors etc.

I have restored the new database with abackup i did this morning, so it is back to how it was, but I would love to know how to add those posts/threads/new members that ive missed in these 3 days or so.

Anyway, thanks again for the info

Dave
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 05-12-2008, 12:15 PM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
 
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 4,496
a server move is a server move.
a software update is a software update.

don't combine them
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 05-12-2008, 04:04 PM
Member
 
Real Name: Dave
Join Date: Oct 2007
Posts: 61
I'm going to delete it all and do it as you say.

If I'm honest, the reason I did them both at the same time was that I was worried in case the upgrade went wrong.

Anyway, I have managed to get a mirror of the old server up and running on the new server.

I'm not exactly sure how to point them both to the same database, is it just a case of changing the config.php to something like this?

For the old server:

Code:
//    ****** DATABASE TYPE ******
    //    This is the type of the database server on which your vBulletin database will be located.
    //    Valid options are mysql and mysqli, for slave support add _slave.  Try to use mysqli if you are using PHP 5 and MySQL 4.1+
    // for slave options just append _slave to your preferred database type.
$config['Database']['dbtype'] = 'mysql';

    //    ****** DATABASE NAME ******
    //    This is the name of the database where your vBulletin will be located.
    //    This must be created by your webhost.
$config['Database']['dbname'] = 'databasename of new server';

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

    //    ****** TECHNICAL EMAIL ADDRESS ******
    //    If any database errors occur, they will be emailed to the address specified here.
    //    Leave this blank to not send any emails when there is a database error.
$config['Database']['technicalemail'] = 'errors@here.com';

    //    ****** FORCE EMPTY SQL MODE ******
    // New versions of MySQL (4.1+) have introduced some behaviors that are
    // incompatible with vBulletin. Setting this value to "true" disables those
    // behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = false;



    //    ****** MASTER DATABASE SERVER NAME AND PORT ******
    //    This is the hostname or IP address and port of the database server.
    //    If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'IP address of new server';
$config['MasterServer']['port'] = 3306;

    //    ****** MASTER DATABASE USERNAME & PASSWORD ******
    //    This is the username and password you use to access MySQL.
    //    These must be obtained through your webhost.
$config['MasterServer']['username'] = 'username of new server database';
$config['MasterServer']['password'] = 'password of new server database';
Is that right?

Thanks for the help.

Edit: The above didn't work, I got a database error on the old server.

Last edited by Dave-M; 05-12-2008 at 06:02 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6  
Old 05-12-2008, 07:05 PM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
 
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 4,496
you need to add an access host on the new box to the old IP.

you can do this in cpanel from your.com:2082/frontend/rvlightblue/sql/managehost.html
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7  
Old 05-12-2008, 07:05 PM
Member
 
Real Name: Dave
Join Date: Oct 2007
Posts: 61
Thanks Brian,

I don't have c-panel, I am using 1&1. (don't laugh )
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8  
Old 05-12-2008, 07:08 PM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
 
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 4,496
its in cpanel... or whatever you use
Attached Thumbnails
accesshost.jpg  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9  
Old 05-12-2008, 07:17 PM
Member
 
Real Name: Dave
Join Date: Oct 2007
Posts: 61
I havent got that.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10  
Old 05-12-2008, 07:20 PM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
 
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 4,496
:shrug:
1&1 sucks... lol

put a ticket in... see if they can guide you
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #11  
Old 05-12-2008, 07:22 PM
Member
 
Real Name: Dave
Join Date: Oct 2007
Posts: 61
lol They do indeed, but I didn't have much choice.

Looks like a call to India is in order then
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #12  
Old 05-12-2008, 07:42 PM
Member
 
Real Name: Dave
Join Date: Oct 2007
Posts: 61
Just spoke to them, they don't allow it, only localhost.

I think I'll try my original idea, it might be a revelation in bodging

Thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads

Thread Thread Starter Forum Replies Last Post
Changing Servers newguy General Discussion 2 02-23-2008 08:04 AM
Moving Servers - How to .... nsusa General Discussion 3 07-15-2007 04:30 AM
What to do When Moving Servers sinjix_media Troubleshooting 0 05-02-2007 06:22 AM
Moving servers question BigBlueBall General Discussion 1 08-11-2006 06:15 PM


All times are GMT -4. The time now is 06:34 AM.


Powered by vBulletin Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc.