Gossamer Forum
Home : Products : DBMan SQL : Discussion :

moving to a new server

Quote Reply
moving to a new server
Hi,

I need to move two gossamer programs to new servers.

I've successfully moved a forum - I found Alex's post very helpful.

http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=176830

Please could I have similar instructions for moving a dbman-sql 2 program.

I'm guessing the sequence should be:

1) install dbman sql on new server
2) copy across database
3) resynch program with database
4) copy across templates, and other customised files - it would be useful to have a list of where these are.

.. anything else ... ?

thanks
Tim
Quote Reply
Re: [timbo] moving to a new server In reply to
OK, I managed it, so here's what I did:

1. copied across database (I used export routine in phpMyAdmin).
2. installed dbman sql 2 on new server; (program working, but I can't see any of my tables)
3. At this point I tried the resynch option in setup .. SQL server, but this didn't help.
4. copied my def files from admin/defs to new server
5. re-copied table Dbsql - after this I can see my tables.
6. look at configData.pm in cgi-bin\admin\Dbsql.
Some of these settings are server specific, but others control how dbman sql works with this database. I copied across the following settings from the old server : 'default_tpl' , 'default_table', 'default_user_table'.
7. Copied my templates across from \cgi-bin\admin\templates.

At this point almost everything works ok.

8. Uploaded updated version of file.pm to fix file upload problem.
this is in
\cgi-bin\admin\GT\SQL
Search for this updated file on this forum.

same for admin.pm

9. (because I had some custom code here:)

uploaded HTML.pm from cgi-bin\admin\Dbsql\Relation (some custom code here) and uploaded home.pm and HTML.pm from cgi-bin\admin\Dbsql.

Smile

I hope this helps others.
Tim Ault
Oxford UK