Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import Database when Changing Servers

Quote Reply
Import Database when Changing Servers
I am consider changing servers in the not too distant future and was wondering the best way to go about it.

I have a lot of custom fields (that imported well following the upgrade from 1.13) so do not really want to manually input those again.

I can safely do a MySQLDump however where I am a bit confused is what process I should follow after that to install LinksSQL on my new server. I was thinking I could do it this way:-

1. Clean install
2. Delete all tables (I believe I need to do this because the following command will not import if there are tables the same in the database - unless I am missing some command line options!).
3. Do a mysql < import.txt command
4. Re-Sync the def files.

Would this work .... or is there an easier way using MySQLMan?

If I can use MySQLMan to do this then I would really appreciate the command sequence I need to enter. I believe I would need to use the SQL Monitor to achieve a straight import/overwrite.

Any suggestions (even if this method is the best to achieve the desired results) would be welcomed.



http://www.AffiliatesDirectory.com - Affiliate Programs Directory
Subject Author Views Date
Thread Import Database when Changing Servers Clint 1278 Mar 7, 2001, 2:43 AM
Post Re: Import Database when Changing Servers
ridesworld 1209 Mar 7, 2001, 6:09 AM
Post Re: Import Database when Changing Servers
Alex 1188 Mar 7, 2001, 6:14 PM