Lounge Network - Knowledge Base

  View Printer Friendly Version Search
KNOWLEDGE BASE HOME » 14. INFORMATION: CORPORATE & BUSINESS HOSTING Viewing Answer
[MYSQL] How do I administer a MySQL database?
The following instructions apply only to our Corporate and Business Class Hosting Plans:

Step 1: In your web browser, go to www.controlpanel.co.nz.


Figure 1

Step 2: Enter your Lounge Network Hosting Control Panel User Name and Password into the appropriate text fields, then click Logon.


Figure 2

Step 3: From the left side of the page, click MySQL Databases under the Services tab. If MySQL Databases is not visible, click the Services tab to expand it.


Figure 3

Step 4: Locate the database you wish to administrate from the list on the right, then click the [Admin] link next to the username that you wish to administrate the database as.


Figure 4

Step 5: phpMyAdmin, a web interface for managing MySQL databases, will be launched in a new window. Select the database you wish to administrate from the menu on the left (shown in figure 5).


Figure 5

Step 6: Each tab (shown in figure 6) allows you to perform a set of administrative actions on your database:
Structure allows you to add, browse, search, insert rows into, empty and drop (delete) tables.
SQL is where raw SQL queries can be executed.
Search can be used to search databases in a more user-friendly method than raw SQL queries.
Query assists you in building a SQL query without needing to fully know SQL syntax.
Export is used to export your database to a variety of formats (SQL, LaTeX, PDF, Microsoft ® Excel & Word and CSV).
Import takes a SQL file and executes it on a database; this can be used to rebuild a database from a backup.
Operations lets your perform other miscellaneous operations, such as creating new tables on a database or renaming or copying a database.


Figure 6

Step 7: By default, the Structure tab is selected. Each table in your database is listed, and for each table you can:
Edit its structure,
Browse its contents,
Search it,
Insert data into it,
Empty it (delete all the data within but leave the structure intact), and
Drop it (delete the table and all its contents)

The buttons for all these actions are illustrated in figure 7.


Figure 7


KNOWLEDGE BASE HOME » 14. INFORMATION: CORPORATE & BUSINESS HOSTING Viewing Answer




Knowledgebase Manager

© Copyright Lounge Network 2001-2017