Databases are the engines behind many scripts, they store the account information, the content and much more.

Creating a Database

  1. Login to your website control panel
  2. Click on MySQL Databases
  3. In the box above Create Database type the name of your database (eg. forum)
  4. Click on Create Database

A new database has now been created with the full name of zpa_123456_databasename and is ready for use with your scripts.


Removing a Database

This will remove not only the domain but also the files, domain records and e-mail so remember to take a backup beforehand.

Removal of a database means removal of EVERYTHING within that database so before removing any database you should always take a backup before hand.

  • Login to your website control panel
  • Click on MySQL Databases
  • From the dropdown menu above Remove Database select the name of your database to remove
  • Click Remove Database

phpMyAdmin is a de facto standard for administrating databases in an easy point-n-click manner.

Accessing phpMyAdmin

  1. Login to your website control panel
  2. Click on phpMyAdmin
  3. Click Connect to this Database next to the database you want to manage

Once launched you will see a screen showing all of the tables within that database, if you have multiple scripts using the same database each will show its own prefix in the table names such as forum_, phpbb_, wp_ and more.


Functions

The tabs at the top allow you to do many functions and operations on your database...

  • Structure displays all of the current tables in an overview
  • SQL allows you to run SQL queries and statements directly
  • Search allows you to build and perform searches within your database tables
  • Query allows you to build complex queries to run on your database
  • Export allows you to create backups of your database
  • Import allows you to import backups or other SQL files
  • Operations allows you to easily create new tables and more

If you were to check a table and select the drop-down menu at the bottom of the list you can perform a number of tasks...

  • Empty allows you to remove ALL records within the selected table(s)
  • Drop allows you to completely remove the selected table(s)
  • Print View generates a reference guide
  • Check performs error checking on your tables
  • Optimize performs a performance check and ensures data and structure are in optimum configuration
  • Repair checks for errors and repairs them if found
  • Analyze collects information about the table, validates its structure and identifies issues

Table View

Opening a table you will be able to see individual field structures within that table, by selecting a check box you can perform operations with that row including editing and more via the icons below.

For more information...

This is a very brief article covering the basics of phpMyAdmin, you should refer to http://wiki.phpmyadmin.net/pma/Articles#English and documentation available within phpMyAdmin for more in-depth information.

Disclaimer

Content and instructions found on third-party sites and services may not be complete, accurate or applicable in whole or part, reliance upon third-party content is solely at your own discretion and risk.