Backing Up Files and MySQL Databases on Linux Servers

You’d think I’d have this memorized by now, but I always mess up the syntax and have to spend a few minutes digging through man pages or wading through search results to find it.

tar -czf [output-file.tar.gz] [input-directory]/
mysqldump -u [username] -p [database name] > [filename]

Adding reCAPTCHA to a Kentico Form

Google reCAPTCHA in a BizForm Tutorial shows how to use reCAPTCHA in a Kentico CMS form. Note my comment in the thread about needing to reference the reCAPTCHA library; if you don’t you’ll get an error saying that it can’t find the assembly.

Theme Metadata not Parsed Correctly

If you create a style.css file for a WordPress theme on a Mac OSX server it will use Mac line breaks (\r) instead of Unix (\n) or Windows (\r\n) ones. get_theme_data() won’t parse the metadata correctly, and it will be look messed up in the admin panel, or break the theme entirely. If your text […]

Developing Mobile Sites

If a client wants their site to be mobile-friendly (and is actually willing to pay for it), then the best way is to create a separate site designed specifically with mobile users in mind. Little Springs Design discusses this in their article about Mobilizing vs Miniaturizing. If the client’s on a tight budget then you’ll […]

myisamchk Error 22 on Windows

If you want to repair tables in a MySQL database, the docs say that you can just run myisamchk –silent –force */*.MYI. That doesn’t work under all version of MySQL for Windows, though, so you may get an error saying, “Error: 22 when opening MyISAM-table ‘*.MYI’. ” If you do, you can run this command […]

MySQL Service Crashes After Drive Failure

If a hard drive fails while MySQL is trying to write to the disk, the database could get corrupted. If that happens then you might see the MySQL service crashing every time when the first request is made after it starts. The error log might display something like this: InnoDB: Database was not shut down […]

Associative Arrays in JavaScript

JavaScript doesn’t support true associative arrays, but because data types are defined as objects, the common syntax works. This is a bad practice, though. You should just create a new object.

Ian Dunn

WordPress Developer

Backing Up Files and MySQL Databases on Linux Servers

Adding reCAPTCHA to a Kentico Form

Theme Metadata not Parsed Correctly

Developing Mobile Sites

myisamchk Error 22 on Windows

MySQL Service Crashes After Drive Failure

Associative Arrays in JavaScript