Account
Overview
Getting Started
Control Panel
FTP
Email Client Setup
HELPFUL TIPS
MySQL
Overview
| MySQL Control Panel Feature | Examples
of SQL Statements | Quick Actions
Advanced Queries | Table
Properties | Table Select
Perl SQL Update Example | Perl While Loop Example
View Dump Database Schema | Using
MySQL With CGI Scripts
References and Tutorials
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.
Copyright © 2000-2004 All rights reserved, Web and Print Design trading as www.webandprint.com.au