We have a customized Openbravo POS v2.2 running with a dozen workstations operating 24x7 a year around. The size of the database has grown to 10GB, and the performance started to degrade so we decided to archive old data and start ...]

We have a dozen websites mostly running WordPress, and one Drupal website on Digital Ocean with a 1GB instance. The server was running flawlessly for 6 months, and then MySQL starts to crash every few days unexpectedly with the fol...]

MySQL documentation states the following with respect to the "character set" and "collation" of the data storage in the database.

To change values of existing integer field (`table` is the table name, and "id" is the column name), you may use the following update SQL command:

We have been using the DirectAdmin control panel for a number of years, and each time we set up a server it is necessary to change the root password. By default, Direct Admin creates a MySql superuser called "da_admin" with a preas...]

I've had a chance to with a Postgres database and came across a table with two primary keys. This intrigues me to look up a definition of primary and unique key. I always thought there would only be one primary key in a table, and ...]