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.
Here we’ll cover how to setup an ntp server that’s using it’s own system time as an accurate time provider, and also setup an ntp peer.