Table Of Contents:

Chapter 1
Account Overview
|
Chapter 2
Getting Started
|
Chapter 3
Control Panel Overview
|
Chapter 4
FTP Instructions
|
Chapter 5
SSH / Telnet
|
Chapter 6
Email Software Setup
|
Chapter 7
File Manager
|
Chapter 8
Change Password
|
Chapter 9
Mail Manager
|
Chapter 10
Site Statistics
|
Chapter 11
Mailing List
|
Chapter 12
Microsoft FrontPage
|
Chapter 13
Site Creation Tool
|
Chapter 14
Counters
|
Chapter 15
Protect Directories
|
Chapter 16
Redirect URL
|
Chapter 17
Search Engine
|
Chapter 18
Formmail
|
Chapter 19
PGP & PGP Mail
|
Chapter 20
Mime Types
|
Chapter 21
Anonymous FTP
|
Chapter 22
Archive Manager
|
Chapter 23
SSL (Secure Server)
|
Chapter 24
MySQL
|
Chapter 25
Shopping Cart
|
Chapter 26
CGI-bin
|
Chapter 27
Real Audio / Real Video
|

Support Manual

Chapter 24 - MySQL



View Dump of Schema

The "View Dump (Schema) of Database" section of the Main Database Management page is useful. Pressing the associated Go button will generate a page containing the SQL statements for recreating the database. If the "Structure and Data" radio button is selected, the SQL statements for INSERTing the data will be generated as well. Turn on the. "Add 'DROP TABLE'" checkbox and the SQL statements to DROP the tables will be included also. When you drop a table, the table is deleted. Turning on the "Send" checkbox, causes the generated SQL statements to be sent to you as a file which you can save to your harddisk.

The "View Dump(Schema) of Table" section of the Table Properties page allows you to obain a dump of a single table. The additional radio button, CVS will return the data in the table with each record as a seperate line. The fields are delimited by the character specified in the "Terminated by" textbox.

The dumped data can be imported into another database or a spreadsheet, or archived for backup.

NOTE: None of the selections above will alter your database.