Managing MySQL Database under Domain Owner

As a domain owner, you can manage the existing MySQL databases created by the admin: add tables, fields.

To be able to manage MySQL databases, you have to be logged in as CP+ domain user. Once you are there, do the following:

1. On the Home page, cilck the MySQL Database icon. You will see the page with existing databases:
   

   

2. Click the database name to get access to tables.
3. To add more tables to this database, click Create a new table. The following page will show:



4. Fill the table creation form:
   • Enter Table name;
   • Optionally, copy fields from table (choose table from the drop-down box);
   • Choose table type from the drop-down box;
   • Set Initial fields: enter field names, choose data type, set type width, if necessary.
5. Click Create.

To manage a specific table:

• Click the field name to modify field parameters. You can change field name, data type, type width. Make sure to click Save to preserve changes.
• Add more fields by choosing the data type from the drop-down box. Fill the form that shows and click Create.
• Click the View Data button to see the data entered into the table. Here you can edit selected rows, add/delete rows.
• Click the Drop Table button to delete table .

To manage database:

• You can back up database by clicking the Backup database button on the databases page.



Fill the form and click Backup now if you want to do it immediately.

• You can enter SQL command that can be executed on particular database by clicking Execute SQL.