Feel free to contact us if you need any informations or if you need a special configuration for your needs.
Our sales department is available to help you to configure your server.
CP 1785
Saint Alexis des Monts
514-317-COLO
7 Days / 24 hrsIn 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…
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…
In this document, we will show you how to dump a table in a particular database and restore a table from a .sql How to dump a specific table mysqldump -u [username] -p [database] [table] > this_table.sql How to restore this table to your database. mysql -u [username] -p -D [database] < this_table.sql
We will show you how to drop a database in command line on a linux server with MySQL or MariaDB installed. First you need to log your MySQL/MariaDB mysql -u root -p List all the databases MariaDB> show databases; +——————–+ | Database | +——————–+ | information_schema | | example | | mysql | | performance_schema…
