[nflug] MySQL Export Tables

[Dennis Ruzeski]

Yup- Sorry I didn't get this up yesterday.

$mysqldump [options] database_name table_name

Simpler than I remember.

--Dennis



On 9/14/07, Franklin Kumro Jr <fkumro at gmail.com> wrote:
> I used Brett's suggestion and found out that many other tables have
> data that contains WEATHER. So I a going to have to refine the grep a
> bit. Still works great though :)
>
> Dennis, did you ever get that example on how to use mysqldump for a
> single table?
>
> Thanks again guys!
>
> On 9/13/07, Brett <brett at consumersbeverages.com> wrote:
> > 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!
> > >
> > >
> > _______________________________________________
> > nflug mailing list
> > nflug at nflug.org
> > http://www.nflug.org/mailman/listinfo/nflug
> >
>
>
> --
> Frank
> Shenanigans!!
> I do the voodoo that I do do with sudo!
> http://www.drunkenfrog.com
> _______________________________________________
> nflug mailing list
> nflug at nflug.org
> http://www.nflug.org/mailman/listinfo/nflug
>