Database Management in myCP®

This document is an excerpt from the myCP® General Information document.

MySQL area gives the following information on your mySQL databases:

Database - This gives the existing database names, which are set by us. Please note that your database name is dependant on your domain name (e.g. abc_com_1)
Size - the size of the database
Users - by clicking on Users, you enter the User Management which allows you to set user permissions for the following; Select, Insert, Update, *Delete, Create, Drop, Grant, Index, Altar, Reference as well as Set New Password
Dump - provides a database Dump tool to transfer your existing database data (Original Server Info) to your new mySQL database (Destination Server Info)
Stats - gives you statistics on your database usage both monthly and yearly, including a highly detailed yearly summary.
PhpMyAdminSuite - phpMyAdmin is a tool for you to manage your MySQL databases via your browser. Currently it allows you to do the following:
- Drop databases
- Create, copy, drop and alter tables
- Delete, edit and add fields
- Execute any SQL-statement, even batch-queries
- Manage keys on fields
- Load text files into tables
- Create and read dumps of tables
- Export data to CSV values
- Administer multiple servers and single databases

For more detailed instructions, please read mySQL database usage.