Knowledgebase

What is phpMyAdmin?

PhpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL databases on the web. It can be used to perform various operations such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

How do I access phpMyAdmin?

**Please change all references of yourdomain.co.uk to your domain.**

You will first need to log in to your cPanel, usually found at http://yourdomain.co.uk/cpanel. Once you have logged in you will need to go to the Databases section and click on the phpMyAdmin link:

The phpMyAdmin screen should appear as follows:

How do I use phpMyAdmin?

You may select any of your databases in the drop down box on the left hand side. In this example, we selected the database ‘Test’

:

Once you have selected a database you can use the tabs at the top of the screen for additional functionality:

Structure: By clicking on this tab you will see a display of the structure and tables of the database that you have selected. You will also have the option of creating additional tables (located at the bottom of the screen), and viewing, editing, and deleting current tables and fields.

SQL: Allows you to run SQL queries on the selected database.

Search: Allows you to search for words or values in the database you have selected. You can specify certain tables and fields to search in or select the entire database.

Query: Query also allows you to run SQL queries on the selected database.

Export: You can easily back up your database by using the export tab. You will need to just select the tables and options you would like and then click Go. You can choose to either export to a file or simply display the data in phpMyAdmin, which you can then copy and paste to another place.

Import: In this tab you may import local files into your database.

Operations: Within this tab you may create a new table, rename the database, and make a copy of the database.

If you encounter any errors or problems with this process, please contact our technical support department. They will be happy to help resolve any issues you experience.