In phpmyadmin
Choose the table from the list... Scroll down the main screen and you
will see this:
View Dump(schema) of table:
You will have options like Structure only, Structure and data, CSV for
MS Excel... Structure dumps the column names and all the field types...
Structure AND data
mysqldump -hhostname -uuser -ppassword database table > table.sql
That will dump the structure and data of the table to the file table.sql
Tyler
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 17, 2002 10:02 AM
Subject: How to save the table
Do you mean run a query that pulls all content in a table?
OR
Something thatÂ’s saves all content of a table?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 17, 2002 8:52 AM
To: [EMAIL PROTECTED]
Subject: How to save the table content into f