This 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…
Category: MySQL
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 Fix “MySQL Command Not Found” Error
June 14, 2024 / MySQLThis guide illustrates how to fix the “MySQL Command Not Found” error. MySQL is an open-source database management system (DBMS) that is well-matched with Linux, Windows, and MacOS. Sometimes you…
How to configure MySQL on Master Node
April 8, 2024 / MySQLThis guide explains how to configure MySQL on Master Node. By default, MySQL listens on the localhost and does not allow connection from the remote system. Therefore, you will need…
How to create PostgreSQL databases
April 2, 2024 / MySQLIn this article, we will explain how to create PostgreSQL databases. Follow the steps to create PostgreSQL databases: At the command line, type this command while logged in as the…
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…
How to Check the MySQL Version on Windows
March 12, 2024 / MySQLIn this guide, we will explain how to check the MySQL version on Windows. Checking the MySQL version on Windows is crucial for ensuring compatibility, security, and effective troubleshooting of…
How to connect to a MySQL database remotely
March 4, 2024 / MySQLThis guide outlines the process of creating a user on your MySQL® server to enable remote connections to a MySQL database. Please note that the instructions provided here are for…
How to eliminate a MySQL User using SSH
January 22, 2024 / MySQLRemoving a MySQL user via SSH is detailed in this guide, where a MySQL user, recorded in the USER table of the MySQL server is deleted along with its linked…
How to Find Objects Between Two Dates in MongoDB
December 18, 2023 / MySQLLearn how to query objects stored in MongoDB between two specific dates in this guide, essential for time-sensitive data applications. Understand about the MongoDB’s data storage- MongoDB uses the BSON…
How to Repair a MySQL Database via cPanel
August 28, 2023 / MySQLIn this article, we will help you in the process of MySQL database repair within cPanel. Follow these steps to fix your MySQL database in cPanel: Log into your “cPanel…
How to activate a MySQL Profile in WHM
August 24, 2023 / MySQLThis article explains how to activate a MySQL Profile in WHM. MySQL profiles define all the data for the connection between the local or remote MySQL server. Steps to be followed-…