7 articles Database

Database Tutorials
MySQL / MariaDB / MSSQL

How to install MariaDB 10.3 on CentOS 7

In this tutorial, we will explain how to install MariaDB 10.3 on your Centos Server Add the MariaDB Repository to your server cd /etc/yum.repos.d/ nano mariadb.repo Add the following block and save [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/rhel7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 Install MariaDB Server yum install mariadb-server mariadb-client -y Start and enable MariaDB onboot systemctl…

How to install MySQL on CentOS 7

In this tutorial, we will explain how to install MySQL on your CentOS 7 Dedicated Server. First you need to download the MySQL repository wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm Install the MySQL repository rpm -ivh mysql57-community-release-el7-9.noarch.rpm Perform the installation of MySQL on your server yum install mysql-server Start MySQL systemctl start mysql Complete the installation and secure your…

How to install MongoDB on Debian 9

In this tutorial, we will explain how to install MongoDB on your Debian 9 Dedicated Server. Update your server before the installation of MongoDB apt-get update && apt-get upgrade -y Install MongoDB apt-get install mongodb -y Commands to start/stop MongoDB systemctl start mongodb systemctl stop mongodb Check the version of MongoDB installed >mongod –version db…

How to Dump and Restore a Database in MySQL or MariaDB with mysqldump

In this document, we will show you how to dump a database with mysqldump and restore it. How to dump the database mysqldump -u [username] -p [database] > this_database.sql Restore procedure If the Database exist, drop the database first. mysql -u root -p MariaDB> DROP DATABSE this_database; exit You need now to create the empty…