Category MySQL

check mysql / mariadb table for primary key

Unknown collation: ‘utf8mb4_0900_ai_ci’

We’ve been running MySQL on our servers for years, this was a first for us. We ran into this issue recently where migrating a database from one server to another generated the following error on the target box: At some…

check mysql / mariadb table for primary key

How to backup your Mysql Databases

Today we’ll look at how to backup your MySQL databases. It’s a good idea to backup your databases on a regular basis so ]you have a working ‘good’ copy in the event of data loss due to failure or if…