Topic: Moving Servers

[ober]

I've got the new FTP info for the new server, and I'm starting the process of moving all the data right now.  I know this place has been lagging a lot and giving timeouts, but it's going to get worse while I make the transfer.  I may end up shutting the board off when I make the full move, just so we don't lose any threads.

But, in the meantime, I'm in the process of moving everything.  Just hold on tight.

[Canuck]

Thanks for the update ober.  Shutting down the boards sounds like a good idea, I think I can live with out entropysink for a few hours.

[Mike]

My Opinion:
Move the files
Shut the board down
Do anything needed to point to the new server
Do a backup of the db
Copy over the db info
Open the new forums

Of course thats assuming the mysql is on the localhost.  If its not then its even easier

[ober]

Here's my plan:

I really hope I don't have to go through the setup of the board again, because I plan to just copy the config files and do an export/import of the entire database structure.

This partly sucks because I have to download all the files for all the styles and then put them back up on the new server.

I also have to download all the member info and upload all that to the new server as well... but that can come after I restart the new forums.

I may have to shut the place down later this afternoon and bring it up again tomorrow when I'm finished (could be most of the day).

[Jake]

My Opinion:
Move the files
Shut the board down
Do anything needed to point to the new server
Do a backup of the db
Copy over the db info
Open the new forums

Of course thats assuming the mysql is on the localhost.  If its not then its even easier

I say backup the DB before you do anything else.

Good luck Oby!

[Ken Fitlike]

Take your time, Ober, and don't worry - I'm sure it'll all work out okay.

If it doesn't we'll just blame whoever the last member to register was.

[Mike]

Reasoning:
-- Main goal is to make everything as smooth as possible --
The files themselves aren't going to change so you can just copy them over and they are ready to go

Make any DNS changes here because well it's gonna take a bit for it to propagate so you want to give it as much time as possible.

Close this forum and he database now will not change.  If you backup prior to this point you'll run the risk of losing data.

Restore db on the new server and reopen.

You keep this one closed and eventually everyone will move over.

This is the one time where allowing remote MySQL connection really helps as you can do the move only closing the forum long enough to move the database and then you can reopen both locations.

[ober]

Well, we've run into another minor glitch... it appears that phpmyadmin isn't setup properly at the moment on the new server.  I'm seeing someone else's blog and comments tables.  

And it's taking fucking forever to grab the data off of the old server because it keeps timing out.

[Mike]

WTF?  Dude this host is really off of their game.

[ober]

Off their game?  Fuck, they don't even have a game.

EDIT: I should clarify... it's not the host I'm complaining about... it's the server we're currently on.  The new server that I'm uploading to is great.  Works like a charm.

The hosting people are awesome and have even refunded us $20 for the downtime... which works out to a little more than 2 free months of hosting.

[Mike]

Well I was trying to be nice since it seems you know them or some shit like that.

[Mike]

You know IMO moving data from one server to another should be the host's job not the clients.....

[ober]

Please read the edit... I don't want any confusion.

[Mike]

Ah ok well as long as the host is being cool I guess I can deal

[ober]

You know IMO moving data from one server to another should be the host's job not the clients.....

It is, and they know that... however the transfer ability on the server we're on is busted.  They've completely moved my 3 other clients that I have hosted with them.