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.
>>> NEXT >>>
[an error occurred while processing this directive]