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…
mariadb
Table is marked as crashed and last (automatic?) repair failed – MySQL / MariaDB / Percona
Today we'll look into repairing a crashed Wordpress database table. The error message could appear in one of many ways, some of them below: [crayon-5e2b41a07e168135195753/] A quick look at the…
Install MySQL / MariaDB on Windows Subsystem for Linux (Ubuntu 18.04)
Windows Subsystem for Linux (WSL) let's you do a lot of interesting stuff inside Windows, biggest of which is installing Linux applications. We'll look into installing MariaDB on Ubuntu running…
404 on Preview – WordPress & Varnish
I've recently moved a number of properties to a server running Apache 2.4, PHP FPM 5.4, MariaDB 10. & Varnish 4.0. The gain in performance is phenomenal. Varnish does wonders…
Check MySQL / MariaDB table for Primary Key
It is pretty straightforward to check a MySQL / MariaDB table for a Primary Key, connect to the db server, login or open up your favorite MySQL client. Without selecting…
Install Mariadb 10.1 – Ubuntu 16.04
Installing the latest stable version of Mariadb, v. 10.1, is pretty straight forward. Start off by heading over to the repo configurator and getting the links for your version of Ubuntu:…
Install MariaDB 10.1 – CentOS 7.2
About MariaDB MariaDB one of the most popular and an enhanced drop-in replacements for MySQL. It was created and is maintained by the original developers of MySQL. MariaDB is very interesting…