Just had a quick look at the mysqldump command myself and I don't see
the --opt or --database switches anywhere.
I think if you tried
mysqldump mystudentdatabase studenttable > myfile.txt
may do the trick.
----- Original Message -----
From: "anna soobrattee" <[EMAIL PROTECTED]>
To: "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 17:30
Subject: mysqldump of one table?
hi
i want to dump the contents of one table into a text file ... can you tell
me what i've done wrong ?
i tried :
mysqldump --opt --tables studenttable > myfile.txt
mysqldump --opt --databases [studenttable] > myfile.txt
mysqldump --opt database [studenttable] > myfile.txt
but all these result in an error ... i can dump the whol database but not
the table studenttable
thanks
anna
---------------------------------------------------------------------
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
