Linux, Apache, Nginx, MySQL, Javascript and PHP

Temporarily changing the auto increment increment in MySQL
MySql

Temporarily changing the auto increment increment in MySQL

It’s possible to temporarily change MySQL’s auto increment increment value to something other than the system setting. This might

Applications

How to change the remote url for your local git repository

If you’ve moved a git repository from one git hosting service to another, transferred from one account to another

ERROR 1115 (42000) : Unknown character set: ‘utf8mb4’ in mysql
MySql

ERROR 1115 (42000) : Unknown character set: ‘utf8mb4’ in mysql

When attempting to load a database dumped with mysqldump into an older MySQL database, I got the error message&

iTunes could not connect to the device error
Miscellaneous Postings

iTunes could not connect to the device error

When attempting to connect to an iPhone 4s running iOS 7, we kept getting the error message "Could not

301 all URLs but one with Nginx
Nginx Web Server

301 all URLs but one with Nginx

There may be times you need to redirect all requests away from a domain except for a single URL,

Linux/Unix/BSD

Change the passphrase for an SSH RSA key file

Use the ssh-keygen command with the -p flag to change or remove the passphrase for an SSH RSA private

How to shrink a VMWare Fusion Linux virtual disk
OSX VMWare

How to shrink a VMWare Fusion Linux virtual disk

VMWare Fusion on Mac OSX allows you to shrink virtual disks easily for Windows virtual machines right from the

Getting back onto Facebook emails
Miscellaneous Postings

Getting back onto Facebook emails

Occasionally I get "Getting back onto Facebook" emails, which I thought was some weird attempt by FB

Linux/Unix/BSD

List directories only with ls

The ls command is used to list directory contents when using the bash shell (and other shells), and has

Suppress the “skipping the data of table mysql.event” message
MySql

Suppress the “skipping the data of table mysql.event” message

When using the mysqldump command to make a back of the mysql database, you might get the message "

Warning: Skipping the data of table mysql.event
MySql

Warning: Skipping the data of table mysql.event

The events table was introduced to MySQL in 5.1.6 and when upgrading you will start to see the warning "

Linux/Unix/BSD

Show the headers only for a request with cURL

cURL is an extremely useful command line tool for making HTTP requests and can be used for diagnosing errors,

Linux/Unix/BSD

curl error [globbing] bad range specification

When testing some website redirects with curl from the command line, I got the error message "curl: (3) [globbing]

Applications

Where are Vudu To Go downloaded movies stored on my Mac?

The Vudu To Go app allows you to download movies you have purchased from Vudu and stores them on

Fix “access denied” error when parsing HTML as PHP with Nginx
Nginx Web Server PHP

Fix “access denied” error when parsing HTML as PHP with Nginx

If you are attempting to get files with a .html extension parsed as PHP with Nginx + php-fpm, you might

MySql

MySQL: order a string column as an integer

If you order a string column that contains only numeric values with MySQL, it will order them as string

Linux/Unix/BSD

Tools for setting up and testing secure certificates

This is a quick reference page for some tools for configuring web server settings and testing secure certificates.

MySql

MySQL queries to get the local part and domain from an email address

This post shows how to extract the local part and domain name from an email address using MySQL. The

1 6 7 8 9 10 50