Moving Servers - Step by Step

[Me2Be]

Can John, James, Martin or some other very knowledge person give me step by step instructions on how to move my Vb to a new server. I would greatly, GREATLY appreciate it! I'm more than likely going to be moving my Vb to another one of my servers during the next few weeks and would like complete detailed instructions on how to do it. (Similar to Charles Capp's version at http://www.scriptkeeper.com/ubb/Archives/Archive-000001/HTML/19990729-2-003004.html Thank you! :D



[Edited by Me2Be on 07-18-2000 at 05:14 PM]

[firewire]

I JUST come from doing so...
- Do a complete dump from your previous sql database (mysqldump -uYOURUSERNAME -pYOURPASSWORD yourdbname > dump.txt)

- upload this dump on your new sql (mysql -uYOURUSERNAME -pYOURPASSWORD yourdbname < dump.txt)

- install vB as usual

- do the "update counters" commands (to make sure there is no glitch at all)

-thats it, forget about UBB :)

[Mike Sullivan]

No no, not quite - you would have problems with the templates at least :)

I'd suggest it in this order:

- dump current DB
- download dump, upload to new server, and import
- upload vB files, but DON'T run setup

...Actually, as I'm writing this post, that brings up a question - if you dump your database, does it dump the "CREATE TABLE xxx (....)" syntax too? If it doesn't (phpMyAdmin does, IIRC), then my instructions are invalid. However, if it does, then that should work fine - as the dump will just recreate all the tables for you.

Oh, and don't forget to change the options relating to your URL!!

[firewire]

Ed, worked here like a charm :) Maybe I am just lucky :)

I DID however a complete database dump using mysqldump, so I got a dump file including the "create table" commands.

I didnt have to import something at all, though. Even though i uploaded the old data and upgraded to 1.3.3 in the same step.

[Me2Be]

Originally posted by firewire
Do a complete dump from your previous sql database (mysqldump -uYOURUSERNAME -pYOURPASSWORD yourdbname > dump.txt)

After I do that, it sits hanging like it's waiting for another command
----> .

Am I enter something here? I tried "\g" but then it gave me an error (error:1064 you have an error in your sql syntax near ... at line 1

[Edited by Me2Be on 07-19-2000 at 11:29 AM]

[Mike Sullivan]

firewire - Did you run install.php? Don't you have double templates? Since the setup makes a bunch of default templates, and the dump tries to INSERT more.

I'd suggest dumping, upgrading to the newest version, testing, and re-dumping.

Then, if everything is a-ok, just run the dump on the new server and upload the vB files.

[firewire]

I didnt run install.php but rather upgrade.php (to upgrade from 1.1.1 to 1.3.3) so no double templates :)

[doron]

m2be - i think a ';' is missing

[Me2Be]

Doron, do you know where?

[doron]

in my mysql telnet if i forget to end the line with a ';', it will show a 2nd arrow, waiting for input

[Me2Be]

Now it's giving me the error immediately. I must be missing something:

mysqldump dbname > dump.txt; and I also have tried
mysqldump dbname > /path/to/dump.txt

Error 1064: You have an error in your SQL syntax near 'mysqldump dbname > dump.txt' at line 1

I have a space in between dbname, >, and dump.txt - should there not be a space in there?

[doron]

dbname should the the database name

[Me2Be]

it is my database name (I just didn't post it on here) :)

[doron]

the way i do it is log in at the same time, so mysqldump -p -u username dbanme > dump.txt

i then get the request for the password, then it creates the file.

[Me2Be]

Okay, I THINK I'm making progress. I did exactly as you said, and after I pressed "enter" it drops to the next line and just sits there hanging (flashing cursor box) - it's been about 5 minutes now. However, it did create the file dump.txt but with 0 bytes.

How long does a backup take? (Especially since there are only about a dozen posts and users - this is a test board).

Thanks so much for trying to help me with this!

[Edited by Me2Be on 07-19-2000 at 12:13 PM]

[doron]

with 780 members and 20,000 posts, it was 17 megabytes big.

[Me2Be]

How long did that take you to backup?

[doron]

2-3 minutes

[Me2Be]

then I'm stumped :(

Thanks for trying!

[firewire]

17.000 posts, 2700 members, db is 18 MB, mysqldump takes 7 secs (dedicated p3-500).

[eva2000]

well i have 200+ members and 9400+ posts and around 7 MB in size and it was backed up almost instantly (p3-500 ded server as well)

[Me2Be]

Chris, Ed, Doron and everyone else - I'm proud to say, with all of your help --

I'VE FINALLY DUMPED!!! (the database that is) ;)

(just for any other newbies who do this, you have to do it from the root directory through telnet, not the mysql directory)

Wow, 58Meg is less than 30 seconds! Now if only I can get the Vb to work with traffic! (not just the importing) :)



[Edited by Me2Be on 08-01-2000 at 04:58 PM]

[Chris Schreiber]

I am just glad that we were able to help you out :)

[Mike Sullivan]

I'm not even going to make a joke about dumping...

[Chris Schreiber]

LOL Mike yeah I know the temptation... I had to refrain from making a response to the question "where should I dump?"

:)

[Me2Be]

Am I going to have to separate you two ;)



[Edited by Me2Be on 10-13-2000 at 07:54 PM]

[Mike Sullivan]

There's still ICQ :p