Hello,
if you want to have a file with just the bare data contents of the table, you simply
do:
mysql> SELECT * FROM table_name INTO OUTFILE '/tmp/lala.txt';
otherwise if you want your data represented in SQL, so that you can reconstruct the
table by importing at a later time (a backup form):
$ mysqldump database_name table_name
and since this gets printed to stdout, you should probably redirect to a file like:
$ mysqldump database_name table_name > table_name.sql.bak
regards,
thalis
On Sat, 10 Feb 2001, Mike Yuen wrote:
> How do I dump all the contents of a table called "clients" into a .txt
> file (or anyother kind of file for that matter).
>
> Thanks for your help.
> Mike
>
>
>
> ---------------------------------------------------------------------
> 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