Tag Archives: mysql

The right kind of database backup

Jul172012

Depending on the arrangement with your data center or hosting provider, they may offer you some form of "off-server" backup. In some cases, you identify a folder for them to backup (which you will copy all of your mission critical … more …

Avoid the MySQL password function

Apr152012

MySQL offers a convenient method to store user passwords, encrypted in a database table. You use the password function both to store a password, and check a plain text string for password matching to authenticate a user. However, if at … more …

CONCAT returning empty value

Jan042012

This is a strange one, and I don't have anything to back it up, just one occurrence. I attempted a CONCAT of a few fields, some of them being NULL values. If a row contained a field with a NULL … more …

MySQL emptying a table

Sep012011

Just a quick MySQL optimization note. Many times we're required to clear a database table and reset the auto increment counter. This is common with import scripts (importing data from Excel, etc). The uncool way to do it: DELETE FROM … more …

MySQL Duplicate Key issues

Apr292011

So you're doing a bulk import into your MySQL database, knowing that your primary key values are unique. Yet, MySQL throws the Duplicate Key message your way. If your primary key is character based, and you are like most, you … more …