General discussion of OpenCATS

Moderators: RussH, cptr13

Forum rules: Just remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but keep comments directed to the topic at hand.
By vvon66
#2564
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!
By vvon66
#2565
I just installed opencats on my windows system. It worked perfectly!!! I followed the instructions and they were wonderfully written. Kudos to the authors of the tutorial!
User avatar
By cptr13
#2566
Thanks. Yes you can transfer from one environment to another. I'm hoping to do documentation on that process soon. If you get ready and it's not done yet, just request help on these forums and someone will walk you through it
By vvon66
#2569
cptr13 wrote:Thanks. Yes you can transfer from one environment to another. I'm hoping to do documentation on that process soon. If you get ready and it's not done yet, just request help on these forums and someone will walk you through it
Thank you for the quick reply!
User avatar
By RussH
#2591
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 all
mysqldump -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 all
mysql -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.
By vvon66
#2600
Thank you Russ! This is probably out of my technical abilities but I'm all for trying something new. I been trying to learn more so as soon as I'm ready, I'll try it or ask for help if I'm not sure I will be successful. Maybe I could try it as a test first to see if I can do it, lol.

You instructions are very informative so I may be able to do it!
User avatar
By cptr13
#2601
There's a gui backup restore feature also look in administration. I don't remember what it's called. But it's obvious. Run the backup, watch and make sure it looks like it completes. Sometimes it works for me, sometimes it doesn't (you can tell by the bar going all the way or hanging.

You should be able to download the backup.bak file to your computer.

Then you use that as the restore file on a new installation.
By vvon66
#2602
cptr13 wrote:There's a gui backup restore feature also look in administration. I don't remember what it's called. But it's obvious. Run the backup, watch and make sure it looks like it completes. Sometimes it works for me, sometimes it doesn't (you can tell by the bar going all the way or hanging.

You should be able to download the backup.bak file to your computer.

Then you use that as the restore file on a new installation.
I will keep that in mind also. Right now I have a local install that I am getting all my data into and learning my way around. A month or so, I'll probably do a transfer to the server. Thank you for the easy suggestion!
By Ilovecats
#2642
Hi

I've just tried the Site Backup in Admin and it gave me a .bak file. Can i email that to myself every week incase computer crashes or gets a virus.
Would it contain all the data I've worked on (CV's, contacts, candidates, job orders, etc) if i would to extract the .bak file to another opencats database on a diff computer?

Thanks
User avatar
By cptr13
#2645
Yes, if the file is small enough to email, that would work fine. The .bak file contains everything, including attached resumes. If your database grows, uploading to google drive, dropbox, etc is a better way to go.

I would strongly urge you to do at least one test restore (fresh install a SECOND opencats version and choose the restore from backup option).

The gui backup has always worked for me, except on certain shared hosts, where it will freeze up. But if you're going to depend on the backup, you need to test it once or twice to make sure it's backing up correctly.

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me