1) Click the database you wish to export, in this example we’ll use the chemiclo_demo database.

2) Next, click on the “Export” tab and select the format in which you want to export the database.

3) Click on the “Go” button to start the export/backup process of the entire database.

4) You can also export only certain tables from your database, from the export tab go to the “Export Method” section click on the “Custom – display all possible options“. This will show you a list of all the tables created in the database.

5) Select the tables you want to export, leave the other options unchanged and click on the “Go” button to proceed.

1) First, we’ll need to select the database, in this example, we’ll use the chemiclo_demo database.

2) You’ll notice that we have a couple of test tables already created, to create a new database table just enter the name of the table in the “Name” field and the number of fields you want for this table and click “Go”.

3) We’ve created the table “demo” and added two columns (name and phone), now we need to set the details of each field within this new table and select Type of data the column will hold.  Some of the most  common types are:

INT = INTEGER – used to store a number that can be written without a fractional component. (e.g. 2, 10, -44). An integer can be zero, positive, and negative.
CHAR = Characters – used to store character string value of fixed length, the maximum number is of characters is 255.
VARCHAR = Variable Length Characters – used to store variable length alphanumeric data and can store up to 65,535 characters.
TEXT = used for holding large amounts of text.
DATE = Will only hold dates.
DATETIME = Will hold both a date and a time.

4) We can also define the Length/Values if necessary, the CHAR type will require you to specify the maximum number of characters allowed. All the other fields are optional, however, if you need more detailed information about all the options available you can check the MySQL Reference Manual.

5) When finished, click “Save”.  A message will appear indicating that your table has been created.

1) Click the database table you wish to run a SQL query on. In this example, we’ll use chemiclo_demo.

2) Click on the SQL tab.

3) Enter the entire SQL query code and click “Go” when finished to execute. You’ll see a confirmation message if the query ran successfully or an error message if there was something wrong with your query.

PhpMyAdmin allows you to perform a wide range of operations with MySQL. In this tutorial, we’ll familiarize ourselves with databases and phpMyAdmin.

1) Log into cPanel

2) Look for the “DATABASES” section and click on “phpMyAdmin “, you’ll be redirected to the phpMyAdmin interface.

3) From this new screen, we have direct access to all the databases created under this cPanel account, they are all listed on the left side. In this example, we have the databases “chemiclo_demo” and “information_schema“. A database consists of one or more tables, the information is recorded in the tables.

4) You can also view all the databases created under this account if you click the “Databases” tab:

Let’s have look at the options available in the top menu from phpMyAdmin

• From the SQL tab, we can open an SQL Query window, here we can enter an entire SQL query code and execute it by pressing “Go“.
• In the Status tab, we’ll find information regarding the MySQL server since the last restart, like the MySQL uptime, number of active connections and traffic volume.
• We can export databases to our local computer if we click on the Export tab and hit “Go”.
• We can import databases from our local computer if we click on the Import tab and hit “Go”.
• In the Variables tab, you’ll see will see a list of the MySQL server system variables.
• In the Charsets tab, you’ll find all the charsets and collations supported by the MySQL server.
• In the Charsets tab, you’ll see a list with all the engines supported by the MySQL server

Let’s move back to the current databases installed on this cPanel account

If we click on the chemiclo_demo database all the tables created under this database will be listed. As we can see in this screen, this database has only 3 tables created.

From here we can see more information about the tables contained in the database, as well as perform several actions:

• Browse a table to see the individual records.
• See the Structure of a table and perform certain actions.
• Search through a table for specific keywords.
• Insert new rows (or fields) into a table.
• Empty or delete the contents of a table.
• Delete or drop an entire table altogether.