Thoughts & Ideas About Web Development

I was getting this cryptic error message earlier. It initially looks like a permissions problem but in fact it was caused by prior use of the SELECT .. INTO OUTFILE which dumped a .csv file into the database directory and was preventing the remove directory command from successfully executing.

That directory is /opt/local/var/db/mysql5/[database_name] on Macports, /var/lib/mysql/[database_name] on Linux (well Debian, at least) and FreeBSD /var/db/mysql/[database_name]

Tags: MySQL

This entry was posted on Tuesday, September 1st, 2009 at 10:55 am and is filed under Solutions to Random Errors. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.