Category Archives: mysql

Pear DB and “DB Error: already exists” On Insert

Posted on June 23, 2010 by Matt

Note that this post relates to using a MySQL database in conjunction with the PEAR DB module, or any other PEAR module that depends on DB – like DB_TABLE (which I’ve been enjoying). You might run into this error if … Continue reading →

Posted in mysql, PHP | Leave a comment

Finding Duplicates in MySQL

Posted on November 25, 2009 by Matt

I get quite a few Excel files from clients that need to get cleaned up and inserted in to MySQL. Sometimes the import goes smoothly, sometimes it doesn’t. This last time, I had 3,741 rows in an Excel file, but … Continue reading →

Posted in mysql | Leave a comment

Using the Shell and Cron to Automate Your MySQL Backups

Posted on April 29, 2009 by Matt

This article describes a simple shell script that backs up your local MySQL databases. It also goes into how to automate the process so it runs everyday using a cron job. Handy! Continue reading →

Posted in mysql, OS X | Leave a comment

phpMyAdmin: Bypass File Upload Size Limit

Posted on November 25, 2008 by Matt

When you want to import a large SQL query in phpMyAdmin, you can run into problems as the default upload size limit is restricted by whatever it is in the php.ini file – and often, you cannot change this or … Continue reading →

Posted in mysql, PHP | Tagged , | 19 Comments