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…

How to Drop and Import a table in MySQL Database via Command line

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

How to install iptables on CentOS 7

CentOS now comes with firewalld instead of iptables at the installation of your Dedicated Server. You can remove the firewalld service and install iptables to manage your firewall rules. First you need to stop and remove firewalld systemctl stop firewalld systemctl disable firewalld yum remove firewalld Now you can install iptables yum install iptables-services -y…

How to install EasyApache4 on WHM

This document explains how to install EasyApache4 on your Dedicated Server with the WHM script.   Requirements Centos 6 or 7. CloudLinux 6 or 7 (cPanel & WHM version 56 or later only). Apache and PHP EasyApache 4 only supports Apache version 2.4. EasyApache 4 supports PHP versions 5.4, 5.5, 5.6, 7.0, and 7.1.   Log…