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 database, this is done using […]
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 […]
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 mariadb-server.example.com Welcome to the MariaDB […]
In linux, the default permissions for any newly created folder is 777 (rwxrwxrwx), and for any newly created file it is 666 (rw-rw-rw-).However when you actually come to create a file or folder, you’ll find that in practice that is not really the case: $ touch testfile.txt $ mkdir testfolder $ ls -l testfile.txt -rw-rw-r–. […]
Here we’re going to talk about what are interactive and login shells.
In windows you’ll have come across shortcuts, e.g. desktop shortcuts. In windows, shortcuts gives you access to the same thing but from a different location. In Linux you can do the same thing, but with a feature called “links”.
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.