This guide shows you how to check the size of PostgreSQL databases and tables using the command line. You can utilize the ‘psql’ command-line tool to find the sizes of…
Category: Database
How to Remotely Connect to MySQL Database
September 18, 2023 / DatabaseTo remotely connect to a MySQL database, you can use a database management tool or command-line interface. Start by ensuring that your MySQL server is configured to accept remote connections.…
How to Rename MySQL DB through cPanel
August 7, 2023 / DatabaseIn this article, we will explore the process of renaming a MySQL database through cPanel. MySQL, a widely used open-source relational database management system (RDBMS), utilizes Structured Query Language (SQL)…
How to Check and Repair a Database in phpMyAdmin
April 11, 2023 / DatabaseThis article helps you in understanding how to check and repair a database using phpMyAdmin in cPanel. 1. Log in to your cPanel account. 2. Click the phpMyAdmin icon from…
How to Update Database Administrator Password in Plesk?
March 27, 2023 / DatabasePlesk is a Web safety control panel that is both innovative and user-friendly. It’s a commercial Web hostility and database server automation program with a control panel targeted at Windows…
PHP Script to Test MySQL Database Connectivity
February 14, 2023 / DatabaseA test for MySQL database connectivity is done using the PHP script mentioned below. It results in showing the tablet names that exist within the specified database. Sample Script Here…
In this guide, you will find how to connect Plesk with external database servers. To join Plesk with an external database server follow these steps: Log in to Plesk. Select…
How To Restore An Account From A Server Backup Disc
February 22, 2022 / DatabaseThis article will show you how to restore a backup that has already been saved on the server. You have a few options to restore an account using WHM’s “Transfer…
The size of SQL Server Database can be reduced/shrunk using any of the following two methods- Method 1: With the help of SQL Server Management Studio Under this method, follow…
Install MariaDB on CentOS 7 with these Simple Steps
December 16, 2016 / DatabaseAn open-source database management system, MariaDB commonly installed as part of the popular LEMP (Linux, Nginx, MySQL/MariaDB, PHP/Python/Perl) stack. The data managed by MariaDB by using a relational database and…