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 you switch over from using PHP’s built-in MySQL functions, over to a database abstraction layer, which [...]

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 somehow wound up with 3,751 rows in the database - what went wrong? Don’t know, [...]

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!

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 simply don’t want to. It tends to default to a measly 2MB.
However, there’s a feature [...]