Home | Website Builders Resource

If you need to access files for importing directly from MySQL you may have encountered an error stating the following. Access denied for user: 'user@localhost' (Using password: YES) The user used to execute the import needs the FILE privilege in order to complete a command similar the one below. LOAD DATA INFILE filename INTO TABLE products FIELDS TERMINATED BY '|' LINES [...]

GoDaddy.com has recently added the ability for shared hosting plans owners to access their MySQL databases directly. Once you start the MySQL creation process you will have the option to Allow/Disallow direct access. This is very useful if you do not want to use phpMyAdmin to administer your MySQL database such as an initial import that exceeds [...]

Here is how to grab and compare a date directly from a MySQL query if you are storing your dates as UNIXTIME. SELECT * FROM table WHERE MONTH(FROM_UNIXTIME(unixtime_fieldname)) = MONTH(CURDATE()) AND DAY(FROM_UNIXTIME(unixtime_fieldname)) = DAY(CURDATE()) AND YEAR(FROM_UNIXTIME(unixtime_fieldname)) = YEAR(CURDATE()) This particular query is looking for any records that have the same month, day and year as today. [...]

Very handy function if you need to replace a string in your MySQL database tables. UPDATE table SET field = REPLACE(field, 'Old Value', 'New Value') Reference MySQL String Functions http://dev.mysql.com/doc/refman/5.1/en/string-functions.html

If you are in a situation where you don’t have access to mysql via command line to import your mysqldump file and need to use phpMyAdmin but limited to the size that you can import SQL Dump Splitter will help you keep your sanity. It will split the files into smaller split files from the master [...]

This is a multi-part post that lists all of the tools that I use on a regular basis as a web developer. The list is Microsoft Windows centric but I will point out the applications that are cross-platform (as best as I can). IDEs (Integrated Development Environment)* Microsoft ASP.NET Both of the IDEs below are top notch and [...]