MySQL

Forcing UTF-8 MySQL query results in PHP

Issuing the query below immediately after establishing the MySQL database connection forces UTF-8 responses to subsequent queries.

Convert Unix dates for export to Excel with PHP or MySQL

Its easy enough to export formatted dates as strings to a .csv file for Excel, but if you want to...

Backup MySQL website databases without mysqldump

To backup the underlying MySQL databases for websites (Joomla! WordPress etc) I usually ssh into the hosting server, run mysqldump,...