MariaDB – Backing up databases

There are 3 levels of mysql database backups you can do: Backup the contents of a single database Backup multiple databases Backup the entire mysql server when creating database backups, the resulting backup files are actrually really big sql files that will repopulate a database. In all cases we create database backups using the mysqldump […]

Read More

MariaDB – Basic MySQL CRUD Operations

In the previous article we saw how to create a new database called ‘online_shop’ and then a table inside this new database called ‘customers’. Now we’re going to show how to create/read/update/delete (crud) content in a table. Let’s see what the situation is: [root@mariadb-client ~]# mysql -u root -p’rootpassword’ -h Welcome to the MariaDB […]

Read More