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?
Jul 26, 2000, 2:42 PM
Veteran (17240 posts)
Jul 26, 2000, 2:42 PM
Post #2 of 4
Views: 1996
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
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
Jul 26, 2000, 9:17 PM
Veteran / Moderator (6956 posts)
Jul 26, 2000, 9:17 PM
Post #4 of 4
Views: 1987
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/
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/