[nflug] MySQL Export Tables

[Franklin Kumro Jr]

Thanks! I feel foolish now seeing how easy that is :(

On 9/14/07, Dennis Ruzeski <denniruz at gmail.com> wrote:
> 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
> >
> _______________________________________________
> 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