vvon66 wrote:Hi - New user here. I want to install opencats on a windows system and use it for a month or so to test it out. My question is...if I want to setup opencats on a server later, is it possible to transfer the database so that I do not lose my information? What would be the process to do that? Could I just copy the database to the server?
Thank you!
Super-simple if you're happy with a little command-line action.
on your source server, login as a user (don't need root) and backup the mysql database;
Code: Select allmysqldump -u opencats-admin -p opencats > backup.sql
(you'll need to replace user 'opencats_admin' and 'opencats' with whatever you have called the admin user and the opencats database. If you have a large database - then you can also choose to compress the sql file at this time
Then - transfer this over to your new server, and once you've setup a new opencats database, you can import the dump file using this command;
Code: Select allmysql -u username -p database_name < backup.sql
If you already have resume's / cv's uploaded, you may as well copy over the whole directory under www/htdocs/opencats so that you get them when you've copied it over, too.
So in summary;
1. Copy over the whole opencats directory
2. Create a new opencats user and database in MySQL on the new server. (just follow the original setup instructions)
3. Copy over the opencats mysql database.