Home User Manual Discussion Forum Search

MySQL 

The Open Dental database is MySQL which is a very robust and reliable database with extensive features and millions of installations worldwide.

If this is a new area for you, the manual is very dry so we will summarize the important aspects here.

  • A database is simply a collection of tables (about 211 in this case). The database 'server' runs on one computer and every copy of Open Dental that connects to it is referred to as a client. The MySQL connection from the client is created after clicking OK on the Choose Database window. The User and Password boxes must match a MySQL username and Password.

  • Overall configuration of MySQL is controlled by the my.ini file on the database server. Inside of the my.ini file is a data path Variable which is set when MySQL is installed or Upgraded. The database files themselves (mysql\data) will always be located on the same computer where MySQL is installed, not to another computer or NAS (too slow).

  • In MySQL, certain words are reserved and cannot be used as identifiers for the database, tables, columns, etc. See http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html. Also, databases should not be named only numbers (e.g. 2014).

  • There are many ways to Back Up the tables. 
    • The simplest is to copy the files when the database is not being used.
    • There are also tools and techniques available for hot backups. Hot backups are preferred when using InnoDb.
      To perform a backup, you don't have to shut down Open Dental, although depending on the backup method, users may be locked out for a few moments. MySQL also keeps logs of changes to the database and can maintain a slave database which is always an exact copy of the master. If your system crashes, you would not lose any data. Improving the speed and effectiveness of the backup process will be a high priority with each Open Dental version release.

  • There are also tools for improving performance, defragmenting, and repairing tables. They all require a degree of skill. They are not essential, but might come in useful.

  • The MySQL server will run as a service on one computer. To easily determine if MySQL is running, use the management console.
    • Right click on My Computer. Select "manage". Open Services and Applications. Open Services. Maximize your window. These are all the programs ('services') that are running in the background without a user interface. MySQL would show as "started".

How to Start/Stop the MySQL Service from Windows CMD

  1. Open CMD
    • CMD may need to be run as administrator depending on Windows permissions settings. Right click the CMD icon, select "Run as Administrator".
  2. To start the MySQL service, type "net start mysql".
  3. To stop the MySQl service, type "net stop mysql".

To access the data in your MySQL database, use the table viewer in User Queries.

 

Open Dental Software 1-503-363-5432