mysql dump

[fatsoPanda]

Hello,

Does anybody know the command to dump a specific table in a database.

I know to do the entire db it's

# mysqldump db > db.sql

but what would it be to do say a specific table in just db?

[mitchind]

Can't do it with that command - as you guessed it's only for complete databases.

What you want is the mysql command combined with the SELECT INTO OUTFILE 'filename' command

[HalfaBee]

I beg to differ

mysqldump [OPTIONS] database [tables]

From the manual

[mitchind]

I learn something every day here.

[fatsoPanda]

Originally posted by HalfaBee
I beg to differ

mysqldump [OPTIONS] database [tables]

From the manual

thank you, worked like a charm