|
This
document will help you learn how to use the web-based MySQL
tools.
The
MySQL tools we provide allow you to view table definitions,
execute a file of MySQL commands, dumpe the contents of your
database, and submit queries to your database in real time
via an easy to use Control Panel web based interface.
To view a table in your database, or to list the tables
in your database, use the MySQL Schema Viewer.
- Click
the MySQL tools in your Control Panel.
- Go
to the "MySQL Schema Viewer" form.
- Type
in the name of the table to view, or leave blank to view
all tables.
- Type
in your MySQL password.
- Press
"View Schema"
- The
output from the operation will be displayed.
To
Import a mysql database from a file, use the MySQL Input Tool.
- Click
the MySQL tools in your Control Panel.
- Go
to the "MySQL Input Tool" form.
- Upload
the file to your website.
- Type
in the name of the file to execute in the Input File field.
- Type
in the name of the file that you want the results of the
commands to be written to in the Output File field
- Type
your MySQL password in the MySQL Password field.
- Press
"Execute SQL Commands"
To dump the
contents of a table to your browser, or to dump the entire
contents of your databse to the broswer, use the MySQL Data
Dumper.
- Click
the MySQL Tools in your Control Panel.
- Go
to the "MySQL Data Dumper" form.
- Type
in the name of the table you wish to view in the Table Name
field. If you want to view all the data in all your tables,
leave this blank.
- Type
in your MySQL password in the MySQL Password field.
- Press
"Dump Database"
- The
output from the operation will be displayed.
To
execute live queries on your MySQL Databse, use the MySQL
Monitor Tool.
- Click
the MySQL Tools in your Control Panel.
- Go
to the "MySQL Monitor Tool" form.
- Type
in the queries you wish to perform in the Commands to submit
field. Be sure to terminate your commands with a "\g".
- Type
your MySQL password into the MySQL Password field.
- Press
"Execute Commands"
- The
output from the operation will be displayed.
|