Page 1 of 1

Moving CATS to a new server...

Posted: 01 Jan 2009, 17:29
by zoomiest
Hey all. I have my LAMP box up, just getting ready to move the DB over this new year's vacation.

Since I have a couple of custom fields, when I install the db fresh, how do I do that? Create a CATS instance in MySQL, and upload the schema?
Or would I just do the default install, and then create the additional fields manually, and reinstall the backup... (Is there a HowTo on this?)

Thanx for all your help, in advance, and best wishes in the new year.

Re: Moving CATS to a new server...

Posted: 02 Jan 2009, 12:24
by RussH
Happy New Year!

..if you're moving over from a windows box, then simply back-up your MySQL database and restore it to your new server. your installation should work with it seamlessly - including the new fields.

If you've changed any of the coding within the modules in your old installation (changed field names etc) then you'll have to modify that all over again of course.

Re: Moving CATS to a new server...

Posted: 02 Jan 2009, 15:41
by zoomiest
...its actually a Linux install (Ubuntu server 8.10)... Will that make any difference?

(and happy new year to all CATS fans...)

Re: Moving CATS to a new server...

Posted: 04 Jan 2009, 18:45
by RussH
you should be fine - the SQL backup and restore will be painless... Keep us updated!

Re: Moving CATS to a new server...

Posted: 05 Jan 2009, 20:49
by zoomiest
Thanks for the help. the install went well.
All the data and attachments dir are in place, and I am up again. Just noticed a Sphinx issue to troubleshoot.

I kept a log of the detailed steps in setting up a Ubuntu server for CATS, with DNS. Let me know if anyone wants to take a look.
Its awesome. I should never have used a VPS before. Thanks for all the help.