Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

migrating to a new server

Quote Reply
migrating to a new server
Any suggestions for a seamless migration? I will be changing hosts and need to migrate the files. From the cgi perspective, is it as easy as just moving the files and changing the address info in the admin console? From the sql side.... what needs to be done there? Any help is appreciated! Thanks!
Quote Reply
Re: [shiner] migrating to a new server In reply to
From the DB side...

1) SQL DUMP all your data from your GT forum database.
2) Save the file as something.mysql.

Then in your new server, execute the something.mysql via shell access to your MySQL server.

This has been addressed in other GT product related forums...search for Moving new server.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [shiner] migrating to a new server In reply to
Hi,

I would:

1. Install the program on the new server and test to make sure it works.
2. Shutdown the original site.
3. Copy your database from the old server to the new server
4. Copy your admin/attachments folder from the old server to the new server
5. Start the new server, it should now have all the information and attachments in it properly.
6. Point people to the new site.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Heckler] migrating to a new server In reply to
Heckler,

Thanks for responding so fast! I am a newbie/intermediate at cgi and clueless on sql - what program do I need to be using to get the sql dump? Telnet? If so, what would I type at the command line? Where would I get shell access? Sorry for the questions, but I would like to learn. Thanks!
Quote Reply
Re: [shiner] migrating to a new server In reply to
MySQLMan, which should've come with GT forum...if not, download the recent of MySQLMan (another Gossamer Threads "product") and use that to "dump" your tables in your GT forum database.

And "shell" access is basically "telnet" access to your account...refer to MySQL (http://www.mysql.com) for references about running commands from telnet.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [Alex] migrating to a new server In reply to
Great! Thanks guys!!
Quote Reply
Re: [Stealth] migrating to a new server In reply to
Stealth -

I was playing with mysqlman today and was able to view the data dump on the screen. Two questions:

1) what type of filetype do I need to name it?

2) once I have the new location ready to go (forum installed) - how to I upload that data onto the new server? I did not see this direction of travel in mysqlman.

Thank you VERY much!
Quote Reply
Re: [shiner] migrating to a new server In reply to
ok, quick follow up:

under the setup tab / sql server, I found "Load table info from an existing set of tables"

that should answer my number 2, but I just need help getting the data dump into a usable format. Def file? what is that?



Thanks!
Quote Reply
Re: [Stealth] migrating to a new server In reply to
Personally, I prefer PHPMyAdmin.
If somebody has PHP allowed on his server, PHPMyAdmin is definitely the best solution.
I like MySQLMan, too, however PHPMyAdmin has very advanced features, especially related to the data import/export.

Advantage of MySQLMan is, that is written in Perl, and is anytime ready to one's hand, since it comes with LSQL & GForum install.

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Quote Reply
Re: [shiner] migrating to a new server In reply to
Ok,

Alex - thanks for responding - I must have missed it before. You may want to add this to the FAQ. Using your steps from about and what I have figured out from this forum and the mysqlman forum (Special thanks to barryb12000 for pointing me towards SQL Monitor):

1. Install the gossamer forum on the new server and test to make sure it works.
2. Shutdown the original site.
-----a. go to the Gossamer Forum ADMIN pannel
-----b. click SETUP
-----c. click DISABLE FORUM
-----d. you can enter a message that users will see - like WE HAVE MOVED CLICK HERE:

3. Copy your database from the old server to the new server
-----a. go to the Gossamer Forum ADMIN pannel
-----b. click on TOOLS
-----c. click on MYSQLMAN
-----d. click on LAUNCH MYSQLMAN
-----e. click on SQL DUMP
-----f. TWO OPTIONS HERE - dump to screen or dump to server
----------i. DUMP TO SCREEN
---------------1. click GO
---------------2. wait until your status bar says done or the bottom of the screen says "# -- Dump ends"
---------------3. from the menu bar of your internet browser select FILE SAVE AS and title it as you chose but give it a .sql ending (i.e. old_forum.sql)
---------------4. OPTIONAL - FTP this .mysql file to your new server

----------ii. DUMP TO SERVER
---------------1. select DUMP TO SERVER and tell it the physical path and file name you want to create (i.e. /home/sites/site72/web/old_forum.sql)
---------------
2. since this file is going to a new server, ftp this file to your local computer
---------------3. FTP the file to the new server

-----g. ON THE NEW SERVER - go into the G-FORUM ADMIN PANEL
-----h. click on TOOLS
-----i. click on MYSQLMAN
-----j. click on LAUNCH MYSQLMAN
-----k. click on SQL Monitor
-----l. Here you have the option to Run queries saved in a file.
----------i. TWO OPTIONS HERE
---------------1. run from server (if you FTP'd the file to the new server, you need the physical path to the file (i.e. /home/sites/site72/web/old_forum.sql)
---------------2. run from file on local drive - click browse to navigate on your computer for the file.
----------ii. This step will recreate all aspects of your old forum on the new server.


4. Copy your admin/attachments folder from the old server to the new server
5. If you have adjusted your templates, copy the admin/templates folder from the old server to the new server
6. Start the forum on your new server, it should now have all the information and attachments in it properly.
7. Point people to the new site.
Quote Reply
Re: [shiner] migrating to a new server In reply to
Ok, I had great success with this! After doing this migration, I have some follow up comments:

1) Make sure you installed the same version of gossamer forum on the new server as you have on the old - save the updating for after the migration.

2) If you are keeping your directory structure the same on the new site as you had on the old site - After saving your .sql file to your hard drive, open it with a text editor before you upload it to a new server. Do a find and replace on your old URL (i.e. FIND: www.oldurl.com REPLACE WITH: www.newurl.com) This saved me A LOT of headache with graphics that I had changed in signature files, e-mail addresses, etc.

3) When you install gforum on the new server - it will create the tables on your new sql server. When you attempt to LAUNCH MYSQLMAN > SQL MONITOR > RUN QUERIES FROM A SAVED FILE you will get an error because it does not want to over-write the tables. SO, I deleted the tables that were created by this new install - heck, they are empty anyways. To do this, you need to click on DROP next to each table from the MYSQLMAN console. This will delete all of the tables. THEN go to SQL MONITOR > RUN QUERIES FROM A SAVED FILE

4) Re-install your plug ins

5) If you modified any of your templates, you may want to go back through them and remove any trace of the old url and replace it with the new one.

6) If you modified permission levels on any actions, you will need to re-edit those in your admin console.



This was VERY easy and I would like to thank everyone for your contributions. I was really worried about this, but looking back - the hardest thing for me was to remember all of the changes and modifications I had done with templates and permissions to the old site and re-implement them on the new site. I had done those changes over several months, so to remember them all in one morning was tough.