help on the mysql version issue after upgraded ubuntu

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
jfd2
Posts: 55
Joined: Sat Feb 16, 2008 10:14 pm

help on the mysql version issue after upgraded ubuntu

Post by jfd2 » Thu Sep 27, 2012 12:38 pm

Hello all,

we used to use the 10.04 LTS as our mysql server and today I upgraded it to 12.04. the issue is that the mysql version is upgraded to 5.5 and looks like the opendental is complaining and ask to "upgrade" it to 4.1. how should I by pass this?

Thanks very much for your help.

jfd
Best regards,

Jeff

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: help on the mysql version issue after upgraded ubuntu

Post by jordansparks » Mon Oct 01, 2012 7:04 pm

You need to have upgraded Open Dental before upgrading mysql.
http://www.opendental.com/manual/mysql55.html
There is no other way to solve your problem. So either roll back your ubuntu update, or else move your database to another computer that's running a lower version of mysql. Then, upgrade Open Dental, test that it's still working. Finally, do your ubuntu update or move your database back to your original server. This is why it's important to:
1. Not be running an ancient version of Open Dental.
2. Use Windows if you want your life to be easier. (Windows would not have updated mysql as part of an OS update.)
Jordan Sparks, DMD
http://www.opendental.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: help on the mysql version issue after upgraded ubuntu

Post by drtech » Tue Oct 02, 2012 4:55 am

just copy your database over to a windows mysql server using sqlyog community edition, update Open Dental to a new version, then you can copy your database back to your Ubuntu server.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: help on the mysql version issue after upgraded ubuntu

Post by jsalmon » Wed Oct 03, 2012 9:28 am

The quickest way to fix this situation is to manually run the Setup.exe for the new version of Open Dental on each workstation (unless you have a lot of workstations then you should do one of the above suggestions). That setup file is located directly in the OpenDentImages share. If that setup file is old, one other place to look is in OpenDentImages\SetupFiles. If that doesn't exist then your only options are the ones mentioned above.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply