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

What do I need to do when I change servers?

Quote Reply
What do I need to do when I change servers?
When I change servers, what do I need to do to transfer my Links files and database successfully? It is as simple as copying everything over and ensuring that the paths to PERL are correct?

Quote Reply
Re: What do I need to do when I change servers? In reply to
1) Export your data from your tables into flat files (.db).
2) Re-create your MySQL tables via the setup.cgi file.
3) Import your data into your new tables via Import.pl.
4) Make sure that all the paths in your .cgi files are correct.
5) Make sure that permissions of your files are correct.

Regards,

Eliot

Quote Reply
Re: What do I need to do when I change servers? In reply to
What´s with copying the whole mysql/data instead of the flatfiles??
I use this to save my data from the net to my server at home (Same Hardware, same system)

Robert

Quote Reply
Re: What do I need to do when I change servers? In reply to
The DATA directory would only be binary compatible with the same version of MySQL, compiled on the same OS/platform as the files were generated on.

It's far, far safer to do a mysqldump and back up those files. They can be imported into any MySQL installation, since they just consist of create table and INSERT commands.

The new MySQLMan allows this to be done more easily. Check out that forum for some info on that.



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