Getting Started Guide - Database Tools

Introduction To Databases
Database Tools - Database Dumper

Database Tools - File Importer
Database Tools - Monitor Tool
Database Tools - Schema Viewer

How Do I Use the Database Tools?
Step one: Log into your Control Panel.

Step two: From Basic Tools, click Database Tools.

Step three: Choose a Database Tool:


File Importer:

Note: The following steps assume you have uploaded an SQL file via FTP to the root directory of your Web site. For information about uploading a file via FTP, go to Publishing with WS_FTP (UNIX).

Step four: From Database Administration, click File Importer.

Image of step four

Step five: From MySQL Input, in the Input File text box, enter the name of the SQL file to be imported. In the Output File text box, enter the name of your choice for the log file to be generated and click Submit.

Note: To designate where the output file is sent, from Send Output to, click to choose File or Display.

Note: In this example, the File is used as the output designation. Depending on which selection you choose, the following information may vary.

Image of step five and note

Note: A message displays stating the output file has been created. To display the output file in your browser window, click Click Here for the Output File. To return to the MySQL menu, click back to mSQL menu.

Image of note

Back to Top


Monitor Tool:

Step four: From Database Administration, click Monitor.

Image of step four

Step five: From MySQL WWW Monitor, in the Commands to submit text box, enter an SQL Statement and click Submit.

Note: In this example, an SQL Create Table Statement is used.

Image of step five and note

Note: To return to the MySQL menu, click back to mSQL menu.

Back to Top

 


Schema Viewer:

Step four: From Database Administration, click Schema Viewer.

Image of step four

Step five: From MySQL Schema Viewer, in the Table Name text box, enter the name of the table you want to view and click Submit.

Note: If you click Submit without entering a table name, a list of table names for your database displays.

Image of step five

Note: Your table data displays.

Image of note

Note: To return to the MySQL menu, click back to mSQL menu.

Back to Top

 


Database Dumper:

Step four: From Database Administration, click Database Dumper.

Imag of step four

Step five: From MySQL Database Dumper, in the Table Name text box, enter the name of the table for which you want to dump data and click Submit.

Note: If you click Submit without entering a table name, all table data in your database is dumped.

Image of step five

Note: Your table data displays. This information can be copied and entered into the Monitor of another account to duplicate your entire database on another server.

Image of note

Note: To return to the MySQL menu, click back to mSQL menu.

Back to Top