Top Nav

Unknown collation: ‘utf8mb4_unicode_ci’

When trying to import MySQL dumps from newer servers to older servers you may get:

or:

The quick and dirty solution is to do a search and replace on the database dump changing “utf8mb4_unicode_ci” and “utf8mb4_unicode_520_ci” to “utf8_unicode_ci”.

This can be accomplished with sed:

0

Partition Large Drive

The classic “fdisk” utility can’t create partitions larger then 2TB. The “parted” utility can be used instead as follows:

 

0

WordPress SSL Termination Fix

Add this code to wp-config.php to stop redirect loops caused by SSL termination on a proxy or load balancer:

 

0

Getting the CA Certificate Chain

Most SSL providers don’t include a complete CA certificate chain with their SSL certificate and it can be hard to track down the correct chain. There’s a great website for this purpose. Check out https://whatsmychaincert.com/ … just paste in the certificate and download the correct cert chain. I’ve used hundreds of times on many different SSL providers and it’s worked every time.

0