Database Corrupted updating to v5.6.29

[savvy]

I always update versions on my home computer before updating my office for precisely this reason...........

I was updating tonight to version 5.6.29.
It was running its course.
All was well until one of the horizontal bars froze up close to the end.
I let it sit during the entire THE UNIT rerun.
When I came back, it hadn't budged.
I CTL ALT DEL...."Open Dental Not Running"
I closed OD.
I tried to open OD, "database corrupted, contact us, must restore from backup."
I rebooted and got the same message.
OD won't let me restore.
Keeps giving same error message.

What's up?

No Cheers

[savvy]

I deleted Open Dental Control Panel.
Using a valid back up of my OpenDentalImages file, I ran the SetUp file.
After OD installed, I tried to open it up.
The Choose Database window appeared.
Server Name = localhost
Database = opendental
User = \]]
Password =
do not show unchecked
Connect to server unchecked
Database Type = MySql

When I click OK........
"Access denied for user \]]@'localhost' (using password:No)

[drtech]

you need to change your user line to:
User=root


Also, you don't have to uninstall/re-install if this happens in the future.
Here is what I do and it works well for the couple of times this has happened to me:

1) install SQLyog (http://dev.mysql.com/downloads/mysql/5.0.html#downloads)
2) BEFORE you run the upgraded OD, using SQLyog
a)make a new database with a name like "5.6.23_backup" or something
b)select your real database (usually "open dental')
c)use the (copy database to different database/host) option to copy your real data base to your new backup database
d)make sure it says "conversion successful" before continuing!
e)THEN run OD to convert
f)if you have any errors like the one above then you can "Empty" the corrupted database and restore back in reverse order like above from your backup

this just gives you an extra layer of "protection" from the unforeseen on conversions!

[jordansparks]

Anytime the update process is forcefully stopped, the database will be corrupted. So that doesn't surprise me. The real question is why it locked up. I don't believe this has happened to anyone else, and we have quite a few people on version 5.6. I'm guessing you were upgrading from version 5.5.

I'm not quite sure why you reinstalled Open Dental. That won't uncorrupt your database. What you need to do instead is to stop mysql server, copy another fresh database to your data folder, restart mysql, and try the conversion again. If that fails, then we will need a copy of the database that is failing to upgrade (not the one that's already corrupted). We will try to upgrade that database on our end in a controlled environment.

[savvy]

David,
Thanks!!!!!!!!
That did it.

CHEERS!!!!!!!!

[savvy]

Jordan,

I was going from 5.6.27 to 5.6.29.

I deleted and reinstalled because I am a dumb a$$.

All is now very much well.

Cheers!!!!

[alexei]

Is it not enough to simply make a copy of the 'data' directory to backup the database, or does SQLyog offer additional benefits? I figure-- KISS: keep it simple, s-----.

[jordansparks]

It is enough to simply make a backup of the data directory. But here are some examples of things that can go wrong:
1. You would have to also remember to copy Setup.exe so that you can have the same version on the backup computer.
2. You might accidentally try to move instead of copy. Doing this just one time could be catastrophic.
3. You might accidentally copy the wrong direction, from the backup to the server. Very bad.
4. You might accidentally save it to the CD folder without following through with the burn.
5. You might accidentally destroy historic backups (I accidentally did this last week).
6. You might accidentally copy over a previous backup, leaving a folder with mixed files from two different versions (we see this a LOT).

My point is that doing a manual backup leaves you wide open for human error issues. And it's not a matter of if, but when.