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 will dump all the data and the structure Data Only will dump just the data After you choose which one, near the bottom of that table, you will see :"Save as File" then click "go" -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 10:02 AM To: [EMAIL PROTECTED] Subject: How to save the table content into file? Hello, I want to store my table in text file, I've tried : select * from news into outfile 'news1.txt' but doesn't work Can you help to do this with phpmyadmin or sql, thanx --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php