I want to make transfer data between MySQL Server to MySQL Local .

Hi, All

I want to make transfer data between MySQL Server to MySQL Local .

My Environment.

Server < --- > My PC Client

Server =
::::: MySQL DB Server ( for Linux )
::::: Apache ..
::::: Linux



PC Client =
::::: Window
::::: MySQL run localhost ( for window )


How i transfer data from mysql server to mysql local .?
Caz i don't want to connect via 3306 port ..
Can i use others way ?


Thank you very much
Pratchaya

Re: I want to make transfer data between MySQL Server to MySQL Local.

Pratchaya wrote:
> Hi, All
>
> I want to make transfer data between MySQL Server to MySQL Local .
>
> My Environment.
>
> Server < --- > My PC Client
>
> Server =
> ::::: MySQL DB Server ( for Linux )
> ::::: Apache ..
> ::::: Linux
>
>
>
> PC Client =
> ::::: Window
> ::::: MySQL run localhost ( for window )
>
>
> How i transfer data from mysql server to mysql local .?
> Caz i don't want to connect via 3306 port ..
> Can i use others way ?
>
>
> Thank you very much
> Pratchaya
>

I would go for replication if that is possible:

http://dev.mysql.com/doc/refman/5.0/en/replication.html

Jonathan