[nflug] MySQL Export Tables

[Dennis Ruzeski]

Mysqldump will do a whole database or a single table. I don't think
you can use a wildcard for tablenames though. I'd do one table at a
time and append the output to your sql file.

I'll verify this when I get home and send better info along.

--Dennis



On 9/13/07, Franklin Kumro Jr <fkumro at gmail.com> 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!
>
> --
> 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
>