Category Archives: mysql
Pear DB and “DB Error: already exists” On Insert
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
Finding Duplicates in MySQL
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
Using the Shell and Cron to Automate Your MySQL Backups
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
phpMyAdmin: Bypass File Upload Size Limit
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

