Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
#3188
Hi,

I am trying to migrate from 9.3 to 9.4 can anyone guide me how do i go about it without loosing the previous data? the documents arent helpful and they wont mention the process.

Regards
Kedar.
#3362
Hi,

I'm also trying to upgrade from 9.3 to 9.4 and I don't want to lose data.

Unfortunately, the GUI backup of my 9.3 isn't working. I've tried the manual approach but not sure if I did it correctly. Below are my steps:

1. Copied the attachments folder in 9.3
2. Used mysqldump in 9.3
3. Copied 9.3 attachments to new 9.4 folder
4. Finally, I've run mysql -u opencats < opencatsbak.sql in my 9.4 installtion

I was able to login but then the following error showed up:

MySQL Query Failed: Table 'cats_dev.user' doesn't exist

SELECT
user.user_name AS username,
user.password AS password,
user.access_level AS accessLevel
FROM
user
WHERE
user.user_name = 'admin'

I'm currently at a lost.
#3363
I was actually looking at this today to try to finish this part of the documentation.
Here are the abbreviated instructions.

Merge/overwrite old attachments folder into new Opencats attachments directory

In phpmyadmin:
Create new database in phpmyadmin - Follow install documentation for this step if necessary
Select newly created database from list on the left
Click import in the upper row
browse
select your opencatsdatabasebackup.sql file
Scroll to the bottom and click "go"
Create user (follow steps from documentation) for the database and assign rights.

In NEW opencats directory
Check for INSTALL_BLOCK file or folder in opencats directory
Install opencats through browser

When you get to the intall type step (new, demo, restore, etc. ) You should see:
Use existing OpenCATS installation and automatically preform any necessary upgrade (recommended).
Select that option.

That should work. Post back with any questions/issues.
#3365
Thanks for clarifying the process. I've successfully migrated to 9.4 but I wasn't able to use phpmyadmin.

Here are the steps I've performed in CentOS7 for reference:
1. Backup attachments and database from old OpenCATS installation.
  • a. To backup attachments, just copy the attachments folder
    b. To backup database, perform the following command:
    Code: Select all
    mysqldump -p -u dbusername opencatsdb > opencatsbak.sql
2. In the new OpenCATS directory, restore the attachments and database.
  • a. To restore attachments, perform the ff. command:
    Code: Select all
    cp -p -r cats-x.x.x/attachments/ cats-0.9.4/attachments/
    b. To restore database, perform the ff. command:
    Code: Select all
    mysql -u opencatsdb < opencatsbak.sql
3. Install OpenCATS_0.9.4 in browser and select upgrade.

Hope this helps others.

However, now I'm encountering a new issue which I can't access previously uploaded attachments and can't upload .doc, .docx, etc. But pdf works fine. The following error shows when viewing previous attachments from OpenCATS:

"Some of the information you provided doesn't follow the correct format and CATS can't interpret what it is. Please go back and complete each field paying close attention to any instructions provided.

This attachment is momentarily offline, please try again later. The support staff has been notified."
#3366
Yes.....I'm not entirely sure what that's all about.

You can create an issue on our github page and the developers will take a look at it. There have been conversations recently on the forums about different formats and their recognition in the system.

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