[nflug] MySQL Export Tables

Brett brett at consumersbeverages.com
Thu Sep 13 17:02:05 EDT 2007


Frank -

You can use mysqldump to dump the whole database then

cat tablename.sql | grep 'WEATHER' > newtable.sql

I've done that to rebuild 1 table from a whole dump.

Brett

Franklin Kumro Jr wrote:
> I have to move only the tables that begin with WEATHER over to a
> different server. Besides selecting into outfiles, is there anyway to
> use mysqldump (or other mysql tools) to export only those tables into
> a sql file so I can import using the mysql command into the other db?
> no php admin either :( which is how I would have done it.
>
> Thanks again!
>
>   


More information about the nflug mailing list