In the previous article we saw how to create backups of our database. Now we’re going to try restoring databases. First thing we need to do is delete our database so that we can start restoring it: We created a backup file for online_shop, so let’s start by deleting that […]
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 […]
In this article we’re going to create a new database and then create a table inside the new database.
In this article we’re going to show some simple MySQL commands to help you navigate your way around databases and tables, and also view a table’s content.
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 […]
Here we cover how to setup a mysql client to connect to a mysql server.
Here we’ll setup a Mysql Server using the MariaDB software.