Software update failure saved by OSX Time Machine!

Today I was trying to upgrade the OS X on my Mac mini via the AppStore which seems harmless and seamless like every other small OS X updates. Unluckily it turned into a nightmare (almost).

I was not paying attention to the details of the Update, it was something like Command Line Tools, Combined update and an update on the Recovery Partition. The install was smooth, after I restart the computer Continue reading “Software update failure saved by OSX Time Machine!”

WordPress command line interface (WP-CLI) guide

WP-CLI is a tool for managing your WordPress website via the command line. This may come in handy if you want to manage your WP instance without going through the web interface, or automate certain operations (change of Settings, perform backup etc.)

For example, here is a sequence of commands for installing a fresh copy of wordpress:

Continue reading “WordPress command line interface (WP-CLI) guide”

Check if two directory is identical with sha1sum

I want to share a little script I wrote that check if two directory is identical rather efficiently. First you may need to understand what sha1sum does.

The sha1sum tool

As the name may suggest, sha1sum compute the SHA-1 checksum of a particular file / text string.

You can see from the above example that sha1sum produce a hash of the content,  Continue reading “Check if two directory is identical with sha1sum”

Weird random MySQL crash solution

After moving one of my node from Linode to DigitalOcean, I have experienced strange crash that appears to be random. After I reboot the process it works for about a week and fails suddenly.

Tools for checking the data in the database

After some research, I think it could be caused by the data inside the database, since I moved all data from the old VPS to the new node and now I’m using a newer version of MySQL (Actually MariaDB). It could run into some compatibility problem.

I strongly recommand you to backup the database before running any checks, upgrade, repairs and optimize actions. You can do so with the command:

This would check the status of all databases in the DB:

This would repair the databases and tables if anything go wrong:

This would upgrade the data if you have upgraded the Mysql version:

Good Luck!