[nflug] MySQL Export Tables

[Shashidhar Manduva]

If MySQL version is same on both the servers, you can ftp or cp the 
files with the wild card
 From the directory where MySQL file exists(on the command prompt) do 
something like the following
scp WEATHER*.* user at remote_server:remote_directory
Run some kind of check either myisamchk or analyze table to make sure 
they are copied properly.
 MySQL tables have .frm, .MYD and .MYI files.
shashi

Dennis Ruzeski wrote:
> 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
>>
>>     
> _______________________________________________
> nflug mailing list
> nflug at nflug.org
> http://www.nflug.org/mailman/listinfo/nflug
>