RE: How to save the table content into file?

2002-02-17 Thread Todd Williamsen
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

Re: How to save the table content into file?

2002-02-17 Thread Tyler Longren
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

RE: How to save the table content into file

2002-02-17 Thread Todd Williamsen
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