This is the process to completely erase a database and import it again via an SQL file. This is useful for instance to sync up a dev installation of a website with the production site. Download a production database SQL backup, do a quick find/replace to change all production URLs to dev URLs and...
While attempting to import an .sql file I experienced the following error Unknown collation: 'utf8mb4_unicode_520_ci'.
It turns out the CentOS 7 repo only offers MariaDB version 5.5, meanwhile www.mariadb.org currently offers version 10.1 and also states that utf8mb4_unicode_520_ci is a support...