How to export data from a MySQL table

[fabiuz]

Hi,

I have a mysql DB with a table with about 3000 records.

How can I export this infomrations in a text file to import them into another DB ?

Thank you!

Fabio

[Anon]

You probably want to use sometihng like mysqldump from the command line or phpMyAdmin (web package).

[dsinicco]

Also, if you have a windows machine, you can pull it from the MySQL database into Access or Excel using MyODBC (get it from the MySQL website).

[mj_23]

Try using this:

select * into outfile 'filename.txt' fields terminated by ',' from table_to_export data

[Anon]

This is the correct answer. It seems to me that it makes much better sense to be dumping into text delimited formats than converting from binary to binary... much less margin for error.

Michael wrote:

Try using this:

select * into outfile 'filename.txt' fields terminated by ',' from table_to_export data