mysql

Your PHP installation appears to be missing the MySQL extension which Is required by WordPress

by
your php installation appears to be missing the mysql extension

If you have received the “Your PHP installation appears to be missing the MySQL extension which Is required by WordPress” error, then this tutorial will be able to help you fix that. This error is triggered when the PHP code in your site is not compatible with the version of PHP your WordPress site is currently using.

More specifically, this problem is related to the outdated MySQL extension which was removed as of PHP 7.0. In this tutorial, we will help you fix the problem with the PHP missing MySQL extension error, and help you complete the WordPress installation successfully.

Read More

MariaDB/MySQL Auto-Сlustering with Load Balancing and Replication for High Availability and Performance

by
mariadb/mysql auto-сlustering with load balancing and replication for high availability and performance

These days high availability and database clustering are very important for highly loaded production applications. If your server is down for a fraction of time, you are losing customers and money. Therefore making a database environment highly available has typically one of the highest priorities. Set up a highly available cluster is not easier for any developers and system administrators.

Read More

How to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04

by

In this tutorial, we will show you how to create a backup of MySQL databases on an Ubuntu 20.04 VPS, and create a backup of the entire /var/lib/mysql directory.

We will create the backup of the databases using MySQL’s command, aptly named mysqldump. After that we will then show you how to perform a backup of the /var/lib/mysql directory where MySQL have been located. Performing regular backups of your database and database server is vital to protecting the data that you have on your server. This way, in case something goes wrong on your Ubuntu 20.04 VPS, or if MySQL breaks for some reason (incompatibilities or otherwise), you’ll have a safe backup that you can revert to and prevent the loss of your precious data.

Once you create a backup of MySQL databases and save them on your server or on a remote location, you can then always be able to restore the databases later from this backup, if needed. Creating a backup of MySQL database is essential for any website owner, and it should be done on a regular basis. Just follow the simple steps in this tutorial and your data will be redundant in no time. Let’s begin.

Read More

How to Install LAMP (Linux, Apache, MySQL, PHP) on Debian 9

by

In this tutorial, we will show you how to install LAMP Stack on a Debian 9 VPS.

A LAMP (Linux, Apache, MySQL, PHP) stack is a combination of open-source software, typically installed on a server used for hosting dynamic websites and web applications. It includes the Linux operating system, the Apache web server, MySQL or MariaDB for data storage and management, and PHP for handling any dynamic content.

Installing LAMP on Debian 9 is a straightforward task and should not take more than 10 minutes. Let’s start with the installation.

Read More

How to Install LEMP on Ubuntu 18.04

by

Install LEMP on Ubuntu 18.04

The LEMP stack is a web development platform for hosting static and dynamic websites. It is a combination of free and open-source software including Linux, Nginx, MySQL, and PHP. It is an alternative to the highly popular LAMP stack, the only difference being having Nginx as a web server instead of Apache.

Read More

How to Install MySQL on Ubuntu 18.04

by

Install MySQL on Ubuntu 18.04

In this tutorial, we will show you how to install and improve the security of MySQL on Ubuntu 18.04. MySQL is one of the most popular and widely-used open-source relational database management systems. It is used for building web applications such as WordPress, Drupal, Joomla, and Magento, and is an important part of the LAMP/LEMP open-source web application software stacks. At the moment of writing this tutorial, the latest supported version from the official Ubuntu package repository is MySQL 5.7. Let’s get started.

Read More

How to Install MySQL on CentOS 7

by

How to Install MySQL on CentOS 7

Let us show you how to install MySQL on your CentOS 7 server. MySQL is a relational database management system that functions through the use of a query system. Created in 1995, it’s an open-source project that is currently developed by Oracle, and has existed since 1995. It’s fast, written in C and C++, and is available on almost any system platform. Its features include cross-platform support, replication support, Unicode support, triggers, cursors, and much more. Since this is such a highly versatile and desirable database-management tool, most people want to install it on their Linux machines, but find that the built-in software repositories install MariaDB, which is a community-developed version of MySQL.

Read More