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
|
|
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.
|