Category Archives: MySQL

LOAD DATA INFILE and FILE Permissions on MySQL

By Donnie Bachan | Published: June 22, 2009
I ran into an issue running the LOAD DATA INFILE command from a PHP script the other day. When I logged in as ROOT and executed the script on MySQL Query Browser it worked like a charm. However, when I executed the script from PHP as another use with only SELECT, INSERT, UPDATE and DELETE [...]
Also posted in Databases | Tagged , , | Leave a comment

Re-installation of MySQL 5.x

By Donnie Bachan | Published: May 6, 2009
A friend of mine recently had an issue while installing MySQL 5.1.34 on a Windows 2003 R2 system using the binary installer. All seemed to have gone well with the install except that when it was done he couldn’t log into the database as root. Obviously, we thought that the password was wrong, so we [...]
Also posted in Databases | Tagged , | Leave a comment

MySQL 5 timestamp error in ColdFusion 8

By Donnie Bachan | Published: February 6, 2009
Scenario: Query grabs user data from MySQL 5 database using the built in MySQL 4/5 driver in ColdFusion 8 on a Windows 2003 Server.   Problem: Cannot convert value ‘0000-00-00 00:00:00′ from column 10 to TIMESTAMP error returned on execution.   Analysis: After a quick search on Google, it appears that the default behaviour for the Connector J MySQL driver is to [...]
Also posted in ColdFusion, Databases, Programming | Tagged , , | Leave a comment

  • Subscribe to my feed Subscriber via Email Follow Me on Twitter! Check me out on Facebook! Check me out on LinkedIn!