Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Changing Servers

Quote Reply
Changing Servers
I have a fairly extensive links database and a number of additional fields that I have created. I 'may' have to change servers shortly so was wondering what backups/upgrade procedures etc I need to follow to transfer all my current info into a new database ..... I imagine it involves a fair bit of work ...

Any advice would be greatly appreciated. I have searched the forum but am having difficulty finding a definitive answer.

Regards,


Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory
Quote Reply
Re: Changing Servers In reply to
Hi Clint,

What I would do is install MysqlMan, and do an SQL dump, this will export all of your tables, and then
MysqlMan can also be used to import data into your tables on your new server.

If I'm not mistaken, there have been other discussions regarding switching servers. Trying a search on exporting or switching servers may yield some helpful info. Hope that helps. :)

Robert Blackstone
Webmaster of Scato Search
http://www.scato.com
Quote Reply
Re: Changing Servers In reply to
There have been a few threads on this as discussed,

but in general, use MySQLMan, "dump" your database,
copy the cgi-bin/links/....

Directories to your local drive.

Copy any image directories you have on the /public/ tree.

On the new server, follow the instructions for setting up Links the first time.

Create the directories in the /public/ tree

Set the permissions on the /public/links/ directory to 777

Copy the cgi-bin/links/ tree you saved over to the new cgi-bin directory.

Set the file permissions on the .cgi files to be 755

set the directory permissions on the defs & backup directory to 777

set the permissions on the files in the templates directory to 777 (if you want to edit them through the built in editor).

Edit the Links.pm file to reflect the new server paths (usually, just the top few $LINKS{...} variables.

Now, using MySQLMan (or a similar program) load the dump file back into the database. If you saved it with the "create tables" commands, it will rebuild the entire database for you.

Then, run setup.cgi to "recreate def files"

You will have copy any def files you made for any _TABLES_ you added to links over manually, and edit the top of the file carefully to reflect the new server paths and passwords, etc. If you didn't add any new tables you don't have to do this.

Edit any "GLOBAL" variables you may have set in the HTML_Templates.pm file, if you have hard-coded any paths into those. (Not everyone will have).

Then, re-index your site.
Rebuild the site,
and with any luck you'll be up and running.

Don't forget to password protect your Links/admin directory. That depends on the tools your server admin set for you.


http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Changing Servers In reply to
Pugdog:

Thanks for that, I appreciate it. I imagine that would be a good time to re-order the fields in each table (the ones I have since added) ...

Regards,

Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory
Quote Reply
Re: Changing Servers In reply to
Hi,

I followed your instructions and everything works fine. We can build, add and delete BUT when we try to re-index the links it works but nothing seems to happen, we get this on the screen:

Code:
Indexing 1979 links. Started at Thu Jan 18 05:37:15 2001
Indexing 656 Categories. Started at Thu Jan 18 05:37:15 2001
Done (0 s)
Before we moved servers this page filled with all the link numbers and categories numbers and took around 18-20s to complete. What is wrong now? Please help!

JeffB


Quote Reply
Re: Changing Servers In reply to
Check your .def files. (in the admin area, Update tables) make sure there is a weight in the fields you want indexed for both the category and links tables.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ