[nflug] MySQL Export Tables
brett at consumersbeverages.com
Thu Sep 13 17:02:05 EDT 2007
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.
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