Articles

How can I backup the database from cPanel

Backing up your MySQL database regularly is one of the most important things you can do to...
How can I empty a MySQL database?

If you need to clear all data from a MySQL database — for example, before restoring a backup or...
How do I backup a MySQL database using phpMyAdmin?

phpMyAdmin makes it easy to export (backup) your MySQL database as a single file that you can...
How do I check the size of my database using phpMyAdmin

You can quickly check the total size of your database and the size of individual tables within it...
How to Assign a New User to a Particular Database?

After creating a MySQL database and a database user in cPanel, you must assign the user to the...
How to Optimize & Repair Tables Using PhpMyAdmin

How to Optimize & Repair Database Tables Using phpMyAdmin Over time, MySQL database tables...
How to create a table via PhpMyadmin?

This guide explains how to create a new table in your MySQL database using phpMyAdmin. Steps to...
How to drop the table via PhpMyAdmin?

Dropping (deleting) a table in phpMyAdmin permanently removes the table and all of its data from...
How to manage databases with phpMyAdmin

phpMyAdmin is a web-based tool for managing your MySQL databases. This guide covers the essential...
How to rename the table via PhpMyAdmin?

Renaming a database table in phpMyAdmin allows you to change a table's name without losing its...
How to repair the database via cPanel

If your MySQL database is experiencing errors, crashes, or corruption, cPanel provides a built-in...
Create a WordPress Admin user for a WordPress Site via MySQL

If you have been locked out of your WordPress admin dashboard — due to a forgotten password, a...
How to Check Database Error Logs in cPanel

Database errors can cause website issues such as blank pages, failed logins, or content not...
How to Create a MySQL Database and User in cPanel

Many applications (WordPress, Joomla, custom scripts) need a MySQL database to store their data....
How to Delete a MySQL Database and User in cPanel

If you no longer need a database or a database user, you can remove them from your cPanel...
How to Export a Database Using phpMyAdmin

Exporting a database creates a backup file containing all the data and structure of your MySQL...
How to Import a Database Using phpMyAdmin

Importing a database restores data from a backup file (.sql, .gz, or .zip) into an existing MySQL...
How to change the collation for the particular table using phpMyAdmin?

If your database displays garbled characters or encoding errors, the collation of one or more...
Understanding MySQL Host and Remote Database Connections

By default, MySQL databases on cPanel are only accessible from the same server (localhost). If...