Articles

  What are the information_schema tables I see when viewing my database?

INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such...

 Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have reached the PHPMyadmin screen, select the database you want to back up. 2) Select the 'export' tab on the top right of the screen. 3) Scroll down the page and click 'Save as file' and click on the 'go' button. This will save a copy of your database on your local computer.

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In the...

 How can I access mysql database remotely?

Under the mysql header in Cpanel, select 'manage mysql'Then scroll down to the 'access hosts'...

 How can I backup a database using phpmyadmin?

Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have...

 How do I add a mysql database in Cpanel?

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In the...

 How do I backup a MySQL database using compression?

In this section, we will show you how to make a backup (also known as exporting) of your database...

 How do I delete a MYSQL database?

Removing a database will delete that database ENTIRELY from the server. Please make sure you...

 How to Optimize database tables?

Please use following steps to optimize your MySQL tables.   1) Log into your cPanel and select...

 How to change password of MySQL user in cPanel?

To change password for mysql user proceed with the steps given below.Step 1: Login to Control...

 How to create a table using PhpMyAdmin in cPanel?

Mysql tables can be created using phpMyAdmin by following the steps below.Step 1: Login to...

 How to delete a mysql database in control panel?

To delete MySQL database in control panel, follow the steps given below,Step 1: Login to...

 How to run / execute mysql queries using phpmyadmin in CPanel?

To execute database queries using phpmyadmin proceed with the steps given below.Step 1: Login to...

 What is Mysql?

MySQL is a Relational Database Management System. A relational database adds speed and...

 phpMyAdmin: Copying a database table

Let’s learn how to copy a database table with below mention steps  1) Click the database table...

 phpMyAdmin: Creating tables in a database

let’s learn how to create a table within a database   1) Select the database 2) Enter a Name...

 phpMyAdmin: Importing databases and tables

Let’s learn how to import a table into a database   1) Click the database you wish to import...