Managing your website

Using Website OS

Managing Email

Using E-Commerce

Building Website

Website Security

Website Statistics

Managing Website

Using the Log Manager

Viewing your server logs

Deleting your log files

Disabling your log files

Printing your log files

Downloading your server logs

Rotating and dating log files

Introduction to database manager

Setting your database manager password

Changing your database manager password

Creating a database

Connecting to your database

Creating a table

Creating an index

Dropping a Database

Using a database

Altering a table

Deleting rows from a table

Dropping a table

Getting information about a table or column

Inserting data into a table

Updating data within a table

Selecing data from the database

Display information about the database

Introduction to Database Manager

To access the Database Manager, select “Website Management” from the main menu, and select “DB Manager” from the Website Management menu.

Database Manager is a web based MySQL client that allows you to create and manipulate a maximum of two MySQL databases.

Database Manager is designed for advanced users. Knowledge of relational databases and SQL is required in order to use this Database Manager efficiently.

Database Manager is best used for creating databases and tables. For populating a database, you should consider using a script(PHP, ColdFusion) or CGI.

Database Manager builds SQL statements from the various options that you select. This is the reason for the "Build SQL Query" button. Viewing the Query gives you an opportunity to review the query before running it. Clicking the "Run SQL Query" button submits the query to the SQL server.

You can find more information about MySQL database at:

http://www.mysql.com/