×

This article covers how to install elasticsearch in the stable version of Ubuntu 20.04. Now you can use the hosted elasticsearch server for doing searches.

If your application generates a huge amount of data and the search procedures are slow, then using elasticsearch will be best.



This article covers the best cross-platform compatible data migration tools available in the market that not just ensure safe and secure data migration but also provide a seamless user experience. IRI NextForm tops our list due to its advanced functionalities along with a simple and easy user experience. DBConvert Studio is another great tool that offers cross-platform and cross-database compatibility and vast support for various formats and databases. 

Next in our list are the data migration tools offered by the information technology industry giants, i.e., data migration tools by AWS, IBM, and Microsoft. All the tools offer seamless data migration capability with slight features and compatibilities modifications that can change according to user preference, and so whatever platform is adopted by the user, according to their requirements, will ensure a seamless and autonomous data migration process.

Data migration is a need of every business, enterprise, and company. Sooner or later, every organization needs to tend to their database management services which always, or in most cases, involve data migrations. 



This article covers how to Install phpMyAdmin with Nginx on Ubuntu 18.04 system. When developing a website or web application, many users need the functionality of a database system like MySQL. However, interacting with the system solely from the MySQL command-line client requires familiarity with Structured Query Language — more commonly referred to as SQL — which can present a major hurdle for some users. phpMyAdmin was created to allow users to interact with MySQL through an intuitive web interface, running alongside a PHP development environment. 


How to Secure phpMyAdmin with Let's Encrypt SSL ?

Before starting, you will need to install the Certbot client to download and install Let's Encrypt SSL.

1. First, add the Certbot repository with the following command:

$ add-apt-repository ppa:ahasenack/certbot-tlssni01-1875471

2. Next, update the repository and install the Certbot client using the following command:

$ apt-get update -y
$ apt-get install certbot python3-certbot-nginx -y

3. Once the Certbot has been installed, run the following command to download and install the Let's Encrypt SSL for your domain:

$ certbot --nginx -d phpmyadmin.domain.com



This article covers how to install mysql 8.0 and Secure MySQL on Debian 9 server. MySQL, the world's most popular open-source relational database management system is not available in the default Debian's repositories. MariaDB is the default database system in Debian 10. 

The MySQL APT repository provides a simple and convenient way to install and update MySQL products with the latest software packages using Apt. The MySQL APT repository provides MySQL packages for the following Linux distros: Debian.


How to Uninstall MySQL from Debian?

To remove MySQL, Run the following commands:

$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
$ sudo apt-get autoremove -y
$ sudo apt-get autoclean
rm -rf /etc/mysql
sudo find / -iname 'mysql*' -exec rm -rf {} \;


How to secure MySQL ?

MySQL comes with a command we can use to perform a few security-related updates on our new install. Let's run it now:

$ mysql_secure_installation

This will ask you for the MySQL root password that you set during installation. Type it in and press ENTER. Then answer a series of yes or no prompts. 



This article covers how to install and Secure MariaDB on a CentOS 7 server. MariaDB is a fork of MySQL managed by the original MySQL developers. It's designed as a replacement for MySQL, uses some commands that reference mysql, and is the default package on CentOS 7.


To Install MariaDB 5.5 on CentOS 7:

1. Install the MariaDB package using the yum package manager: 

$ sudo yum install mariadb-server

2. Once the installation is complete, start the MariaDB service and enable it to start on boot using the following commands: 

$ sudo systemctl start mariadb 
$ sudo systemctl enable mariadb


To install MariaDB on CentOS 8:

1. Open the terminal application. Another option is to log in using the ssh command:

 ssh user@centos-8-server-ip

2. Install the MariaDB on CentOS 8 by running the command:

$ sudo yum install mariadb-server

3. Secure the MariaDB server in CentOS 8 by running the command:

$ sudo mysql_secure_installation

4. Finally test MariaDB installation by running the command:

$ mysql -u root -p


MariaDB vs MySQL:

Even though MariaDB is a fork of MySQL, these two database management systems are still quite different: 

MariaDB is fully GPL licensed while MySQL takes a dual-license approach.

MariaDB supports a lot of different storage engines. 

In many scenarios, MariaDB offers improved performance.



This article covers step by step process to Install and Configure phpMyAdmin with Apache on Debian 9 system. The phpMyAdmin utility is a graphical database management tool. By installing phpMyAdmin, you no longer need to use a default command-line interface to manage your databases.


To install wget:

1. Access your terminal window, and update your software package lists using the following command:

$ sudo apt update

2. The wget utility allows you to download files directly from the terminal window. Enter the following command to install the wget tool:

$ sudo apt install wget -y


To install Apache on Debian:

1. Open a terminal window, and install Apache by entering the following command:

$ sudo apt install apache2 -y

2. Enter the following command to make sure the Apache service is running:

$ systemctl status apache2

In the output, you should see a green status that says active (running).


To Install PHP on Debian 10:

1. Install core PHP packages and Apache and MySQL plugins with the following command:

$ sudo apt install php php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql -y

2. Once the installation process is complete, verify that PHP has been installed:

$ php --version

The system displays the current version of PHP, along with the date of the release.



This article covers how to install MariaDB on Ubuntu 18.04 server. Also, you will learn how to secure and connect to MariaDB server. MariaDB is an open-source relational database management system, commonly used as an alternative for MySQL as the database portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. Basically, It is intended to be a drop-in replacement for MySQL.


How to Install MariaDB ?

1. To install it, update the package index on your server with apt:

$ sudo apt update

2, Then install the package:

$ sudo apt install mariadb-server



This article covers how to install and secure a MySQL server on a CentOS 7 server. MySQL is one of the most widely used database management systems for websites and server applications.


To start the MySQL server daemon with the following command:

$ sudo systemctl start mysqld

systemctl doesn't display the outcome of all service management commands, so to be sure we succeeded, we'll use the following command:

$ sudo systemctl status mysqld

To configure MySQL, run the following command:

$ sudo mysql_secure_installation

To Current MySQL Version, run the command:

$ mysql -u root -p


Terms used in Managing MySQL User Permissions:

  • SELECT – users can read through the database using the select command.
  • CREATE – they can generate new tables.
  • DROP – allows users to remove tables.
  • DELETE – users can take out rows from tables.
  • INSERT – lets users add in rows into tables.
  • UPDATE – enable them to update the rows.
  • GRANT OPTION – they can grant or remove the privileges of other users.



This article covers how to install MariaDB version on a Debian 10 server, and verify that it is running and has a safe initial configuration.


How To Install MariaDB on Debian 10 ?

1. To install MariaDB, update the package index on your server with apt:

$ sudo apt update

2. Then install the package:

$ sudo apt install mariadb-server

3. To Configure MariaDB, Run the security script:

$ sudo mysql_secure_installation



This article covers how to install LAMP on Debian server along with PHPMyAdmin to manage your database. LAMP stands for Linux OS, with Apache web server, Data store in a MySql or MariaDB database, and dynamic content is processed by PHP.


To install Apache on Debian:

1. Run the following command:

$ apt-get install apache2

2. To restart your web server by typing the following command:

$ service apache2 restart



This article covers how to Install a LEMP Stack on Ubuntu 20.04 LTS. LEMP stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web apps. LEMP stands for Linux OS, with the Nginx (pronounced like "Engine-X") web server, Data store in a MySQL database, and dynamic content is processed by PHP.


To install Nginx Web Server:

1.  Run the commands below to install Nginx.

$ sudo apt update
$ sudo apt install nginx

2. Allow traffic on port 80.

$ sudo ufw allow 'Nginx HTTP'

You can verify the change by running:

$ sudo ufw status



This article covers step by step process to install a LAMP stack on an Ubuntu 18.04 server. LAMP stack is a group of open-source software that is typically installed together to host dynamic websites. LAMP stands for Linux OS, with Apache web server, Data store in a MySQL database, and dynamic content is processed by PHP.


To Install Apache and Update the Firewall.

1. Install Apache using Ubuntu’s package manager, apt:

$ sudo apt update
$ sudo apt install apache2

2. Allow incoming HTTP and HTTPS traffic for this profile:

$ sudo ufw allow in "Apache Full"



This article covers how to install MySQL version 8.0 on an Ubuntu 20.04 server. By completing it, you will have a working relational database that you can use to build your next website or application.

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses Structured Query Language (better known as SQL) to manage its data.


To install MySQL using the APT package repository:

1. Update the package index on your server if you've not done so recently:

$ sudo apt update

2. Then install the mysql-server package:

$ sudo apt install mysql-server

This will install MySQL, but will not prompt you to set a password or make any other configuration changes. 

Because this leaves your installation of MySQL insecure, we will address this next.



This article covers MongoDB installation on CentOS 8 system.

Instead, it uses JSON-like documents with dynamic schemas, meaning that, unlike relational databases, MongoDB does not require a predefined schema before you add data to a database. 

You can alter the schema at any time and as often as is necessary without having to set up a new database with an updated schema.


How to Start the MongoDB Service and Test the Database on Ubuntu?

1. Run the following systemctl command to start the MongoDB service:

# sudo systemctl start mongod

2. Then check the service's status:

# sudo systemctl status mongod

This command will return output like the following, indicating that the service is up and running

3. After confirming that the service is running as expected, enable the MongoDB service to start up at boot:

# sudo systemctl enable mongod


How to Managing the MongoDB Service on Ubuntu?

1. The systemctl status command checks the status of the MongoDB service:

# sudo systemctl status mongod

2. You can stop the service anytime by typing:

# sudo systemctl stop mongod

3. To start the service when it’s stopped, run:

# sudo systemctl start mongod

4. You can also restart the server when it’s already running:

# sudo systemctl restart mongod

5. If you ever wish to disable this automatic startup, type:

# sudo systemctl disable mongod

6. Then to re-enable it to start up at boot, run the enable command again:

# sudo systemctl enable mongod



This article covers how to take Backups and restore a MySQL database on Red Hat Enterprise Linux 8.


Advantage of logical backup:

The main advantage of logical backup over physical backup is portability and flexibility. 

The data can be restored on other hardware configurations, MariaDB versions or Database Management System (DBMS), which is not possible with physical backups.

Note that physical backup must be performed when the mariadb.service is not running or all tables in the database are locked to prevent changes during the backup.


The mysqldump client is a backup utility, which can can be used to dump a database or a collection of databases for the purpose of a backup or transfer to another database server. 

The output of mysqldump typically consists of SQL statements to re-create the server table structure, populate it with data, or both. 

Alternatively, mysqldump can also generate files in other formats, including CSV or other delimited text formats, and XML.


Advantages of Physical backup:

1. Output is more compact.

2. Backup is smaller in size.

3. Backup and restore are faster.

4. Backup includes log and configuration files.


You can use one of the following MariaDB backup approaches to back up data from a MariaDB database:

1. Logical backup with mysqldump

2. Physical online backup using the Mariabackup tool

3. File system backup

4. Replication as a backup solution


To Backing up an entire database with mysqldump:

Execute the command:

# mysqldump [options] db_name > backup-file.sql


Using mysqldump to back up a set of tables from one database:

To back up a subset of tables from one database, add a list of the chosen tables at the end of the mysqldump command:

# mysqldump [options] db_name [tbl_name …​]



To restore the data while keeping the original backup files, use the following procedure:

1. Run the mariabackup command with the --copy-back option:

$ mariabackup --copy-back --target-dir=/var/mariadb/backup/

2. Fix the file permissions.

When restoring a database, Mariabackup preserves the file and directory privileges of the backup. However, Mariabackup writes the files to disk as the user and group restoring the database. 

For example, to recursively change ownership of the files to the mysql user and group:

# chown -R mysql:mysql /var/lib/mysql/

3. Start the mariadb service:

# systemctl start mariadb.service



This article covers how to install and configure ClamAV and ClamTK to scan for malware on Ubuntu 20.04. 

There aren't many viruses made for Linux distributions and as such, most people who use such systems don't even bother using antivirus software. 

Those however who do want to be able to scan their system or other Windows-based systems that are connected to a Linux PC through a network can use ClamAV. 

ClamAV is an open-source anti-virus engine that is built to detect viruses, trojans, malware, and other threats. 

It supports multiple file formats (documents, executables, or archives), utilizes multi-thread scanner features, and receives updates for its signature database at least 3-4 times a day.


To ClamAV Antivirus on Ubuntu:

The first step is to install and get the latest signature updates. To do this on Ubuntu, you can open a terminal and insert "sudo apt-get install clamav" and press enter.

$ sudo apt install clamav

You may also build ClamAV from sources to benefit from better scanning performance.

To update the signatures, you type "sudo freshclam" on a terminal session and press enter.

$ sudo freshclam

Now we are ready to scan our system. 

To do this, you can use the "clamscan" command. 

This is a rich command that can work with many different parameters so you'd better insert "clamscan –-help" on the terminal first and see the various things that what you can do with it:

$ clamscan –-help


To Update ClamAV Signature Database:

1. Stop the ClamAV process:

$ systemctl stop clamav-freshclam

2. Manually update the ClamAV signature database:

$ freshclam

3. Restart the service to update the database in the background:

$ systemctl start clamav-freshclam



This article covers how to resolve the above maiadb problem "Job for mariadb.service failed because the control process exited with error code" which may arise during the installation of #MariaDB on #CentOS 8.

The /var/lib/mysql directory is not empty when MariaDB is installed, it contains e.g. the 'mysql' database and some other files. 

Recreating the folder, even with correct permissions, will not help you. 

Either MariaDB has not been successfully installed or the directory was removed. Reinstall MariaDB to get a working basic database system back.

Also, you can give access /var/log/mysql/* to mysql by running the command:

sudo chown mysql:mysql /var/log/mysql/*


MariaDB offers more and better storage engines, NoSQL support, provided by Cassandra, allows you to run SQL and NoSQL in a single database system. 

MariaDB also supports TokuDB, which can handle big data for large organizations and corporate users.


To view mysql error logs:

1. edit /etc/my.cnf [mysqld] log=/tmp/mysql.log.

2. restart the computer or the mysqld service service mysqld restart.

3. open phpmyadmin/any application that uses mysql/mysql console and run a query.

4. cat /tmp/mysql.log ( you should see the query )



This article will guide you on how to install MariaDB on your CentOS 8 system. Now you can create new databases and grant privileges to other database users. Also, you can add users and create new databases for web or desktop applications which will be written in PHP, Python, and so on.

In MariaDB replication is faster whereas in MySQL replication is slower. 

MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition. 

MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.


To uninstall MariaDB and install mysql:

1. Purge mariadb sudo apt purge mariadb-* Remove all databases ('Yes' answer)

2. Purge mysql sudo apt purge mysql-*

3. Remove folders: sudo rm -r /usr/share/mysql/ sudo rm -r /etc/mysql/ sudo rm -r /lib/systemd/system/mysql.service.

4. Now you can try to install oracle mysql: sudo apt install mysql-server.



This article will guide you on the different methods to conveniently install and start the MariaDB service on a Debian 10 system. Also, we dealt with how to easily remove MariaDB from your Debian 10 system. 

In MariaDB replication is faster whereas in MySQL replication is slower. 

MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition. 

MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.

Since MariaDB is a fork of MySQL, the database structure and indexes of MariaDB are the same as #MySQL. 

This allows you to switch from MySQL to MariaDB without having to alter your applications since the data and data structures will not need to change. Data and table definition files are compatible.


To install #MariaDB on #Debian , follow these steps:

1. First update the apt packages index by typing: sudo apt update.

2. Once the packages list is updated, install MariaDB by running the following command: sudo apt install mariadb-server.

3. The MariaDB service will start automatically.



This article will guide you on how to run commands as root user using nonuser, su, and sudo utilities.




More Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on IbmiMedia.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com