Upgrade to MySQL 5.6 64-bit:

  1. UPGRADE Open Dental to the latest version
  2. May require: Tools > Misc Tools > Shutdown All Workstations
  3. CMD as admin
  4. Net stop MySQL
  5. cd\
  6. cd “Program Files (x86)\MySQL\MySQL Server 5.5\bin”
  7. MYSQLD -remove
  8. appwiz.cpl
  9. Backup Live Databases
  10. Download and install 2010 C++ RedistMySQL 5.6 64-bit version. (defaults)
  11. Move “C:\Program Files (x86)\MySQL\MySQL Server 5.5\my.ini” “c:\Program Files\MySQL\MySQL Server 5.6”
  12. cd\
  13. CD “Program Files\MySQL\MySQL Server 5.6”
  14. NOTEPAD my.ini
  15. Update “basedir” to read basedir=”C:/Program Files/MySQL/MySQL Server 5.6/”
  16. Exit
  17. Save
  18. cd\
  19. cd “Program Files\MySQL\MySQL Server 5.6\bin”
  20. mysqld –install
  21. Netstart MySQL
  22. CD “c:\Program Files\MySQL\MySQL Server 5.6\bin”
  23. mysql_upgrade -u root -f
  24. net stop mysql
  25. net start mysql
  26. “C:\Program Files (x86)\Open Dental\OpenDental.exe”