Sometimes, hardware problems, server breakdowns, or unplanned shutdowns can destroy MySQL databases. Database issues may result from some tables becoming illegible or inaccessible. For both beginners and system administrators, this…
Category: MySQL
How to Install MySQL on Linux Using the MySQL APT Repository
October 7, 2025 / MySQLMySQL is one of the most widely used open-source relational database management systems, running innumerable websites and applications. Installing MySQL using the official MySQL APT repository guarantees that you have…
How to rotate MySQL binary logs manually
July 23, 2025 / MySQLMySQL binary logs record all changes to the database and are important for replication and point-in-time recovery. Over time, these logs can grow large and consume disk space. While MySQL…
How to Use Cron for MySQL Backups and Auto-Deletion
July 9, 2025 / MySQLRegular backups are vital for safeguarding your MySQL data. This guide explains how to automate daily MySQL database backups using cron and how to clean up old backup files older…
How to update Database User Privileges in cPanel
May 1, 2025 / MySQLManaging user privileges is very important for maintaining control over your databases. With cPanel, you can easily modify database user permissions to suit your specific needs. Follow the steps below…
How to Prevent users from viewing all Microsoft SQL databases
March 22, 2025 / MySQLThis article illustrates how to prevent users from viewing all Microsoft SQL databases as the users with basic public access can often view a list of all databases on the…
How to set up Database Replication in MySQL/MariaDB
March 7, 2025 / MySQLThis guide explains how to set up database replication in MySQL/MariaDB. Database replication in MySQL/MariaDB is a process that lets data from one database (Master) be replicated to another database…
How to Optimise MySQL Performance using MySQLTuner
February 10, 2025 / MySQLMySQL performance optimisation is crucial for ensuring database efficiency, stability, and speed. MySQLTuner is a powerful script that analyses your MySQL server’s configuration and provides recommendations for performance improvements. This…
How to Check and Repair a Corrupted MySQL Database Table Using SSH
November 18, 2024 / MySQL Sales FAQThis guide explains how to use MySQLcheck to repair a corrupted database table. Checking and repairing a corrupted MySQL database table using SSH ensures the integrity of the database, stopping…
How to export/import a MySQL database through SSH
November 6, 2024 / MySQLIn this article, you will learn how to export and import a MySQL database via SSH. For databases larger than 128MB, using SSH is recommended for the export/import process. …
How to use phpMyAdmin to export MySQL database
July 3, 2024 / MySQLThe article will show you how to import your MySQL database files in the Plesk control panel using phpMyAdmin. Follow the steps as given below: Log in to your Plesk…
How to reduce/shrink the SQL file size
June 16, 2024 / MySQLReducing/shrinking the SQL file size is essential for optimising database performance, saving storage space, and confirming efficient data management. Follow the steps- Open SQL Server Management Studio and right-click on…
How to configure MySQL on master node
April 8, 2024 / MySQLThis guide explains how to configure MySQL on a master node for replication. By default, MySQL listens on localhost and does not allow remote connections. To enable replication, MySQL must…
How to connect to PostgreSQL using psql
April 1, 2024 / MySQLThis guide shows you how to use a tool called psql to connect to a PostgreSQL database from your computer’s command line. It is like a special program that lets…