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.
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.
