Untitled

Account Overview - Getting Started - Control Panel Overview - Chapter 1 FTP Software Setup
Chapter 2 SSH / Telnet Setup - Chapter 3 Email Software Setup - Chapter 4 CGI-Bin - Chapter 5 Secure Server
Chapter 6 FormMail - Chapter 7 MS FrontPage - Chapter 8 CGI Scripts - Chapter 9 ASP - Active Server Pages
Chapter 10 JSP - Java Server Pages - Chapter 11 PHP - Chapter 12 Real Audio/Real Video
Chapter 13 File Manager - Chapter 14 Mail Manager - Chapter 15 Changing Passwords - Chapter 16 Site Statistics
Chapter 17 Network Tools - Chapter 18 FTP Manager - Chapter 19 Backup Manager - Chapter 20 Password Protect Directories
Chapter 21 Custom Error Pages - Chapter 22 MySQL & PhpMyAdmin - Chapter 23 Mime Types - Chapter 24 CronTab
Chapter 25 Entropy Chat - Chapter 26 Akopia Shopping Cart - Chapter 27 Search Engine Submission
Chapter 28 PGP & PGP Mail - Chapter 29 Subdomains

Chapter 22 - 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 hard disk.

The "View Dump(Schema) of Table" section of the Table Properties page allows you to obtain a dump of a single table. The additional radio button, CVS will return the data in the table with each record as a separate 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.

Back To Top