MySQL tips and tricks
MySQL dump table as inserts (November 4, 2015)
How to dump the data from a single table as INSERT statements in MySQL...
How to dump the data from a single table as INSERT statements in MySQL...
Using PHP + MySQL with UTF-8 support for correct encoding (November 13, 2012)
If you are having problems with non-ASCII encodings such as the British pound sign then you are probably not using UTF-8 all the way through your HTML, PHP, and database....
If you are having problems with non-ASCII encodings such as the British pound sign then you are probably not using UTF-8 all the way through your HTML, PHP, and database....
SQL get MAX value or NULL (LEFT JOIN example) (March 5, 2012)
SQL example to get the MAX value from the right hand table or NULL if there is no matching row...
SQL example to get the MAX value from the right hand table or NULL if there is no matching row...
Export data from MySQL into CSV file (February 23, 2012)
How do you export the result of a MySQL query into a CSV file ...
How do you export the result of a MySQL query into a CSV file ...
MySQL create database with underscore or dash in the database name (February 15, 2012)
Here is how to create a MySQL database with underscores or dashes in the database name...
Here is how to create a MySQL database with underscores or dashes in the database name...
MySQL fails to start after package update: unknown variable lc-messages-dir (November 8, 2011)
After a package update on Debian my MySQL refused to start and syslog contained the following message [ERROR] /usr/sbin/mysqld: unknown variable 'lc-messages-dir=/usr/share/mysql'...
After a package update on Debian my MySQL refused to start and syslog contained the following message [ERROR] /usr/sbin/mysqld: unknown variable 'lc-messages-dir=/usr/share/mysql'...
ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.0.1' (113) (November 3, 2011)
How to solve MySQL Error 2003 (HY000) when trying to connect to a MySQL server on a remote machine?...
How to solve MySQL Error 2003 (HY000) when trying to connect to a MySQL server on a remote machine?...
Ask me about
AdSense Android ant Apache Applet Artigo C++ CI codec console CSS Debian DemoScene deployJava.js diff DIY Eclipse Excel fdisk find Firefox FixPC Flash fuse GC git GPG grep HotSpot hsdis HTML Icedove icedove Iceweasel ImageMagick iOS iPhone iSCSI ISO JarScan Java JavaFX JavaScript JCrete JDBC JDK Jenkins Jessie JIT JITWatch JVM lambdas lame Linux linux low latency LVM Mac MacPorts maven Microsoft mkfs mp3 MySQL Networking networking NFS Obj-C OpenJDK OpenJFX openSSL openssl optimisation OSX Patterns PHP PIX PostgreSQL powersaving PS3 Puzzle qmail Raspberry Pi RaspberryPi Safari samba Samba Scala scp scponly SEO ssh sshfs stunnel svn SWT sysctl syslog-ng tcpkill Thunderbird tmpfs Tomcat tripwire Ubuntu Unity UTF-8 vi VirtualBox website Websites wget Windows Windows 8 Word Xcode xen ZTE Blade