How to change Crontab default editor

In this tutorials, we will show you how to change the crontab editor with nano. Requirements : Dedicated Server root access Install nano package on your server CentOS yum install nano -y Ubuntu apt-get install nano -y Change the crontab editor export EDITOR=nano Use crontab with nano crontab -e Add your cronjob, edit/save and use…

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 Drop a MySQL Database on Linux via Command line

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…