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

[Pratchaya]

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

[Drakazz]

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

With MySQL there always comes a mysqldump tool.

http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

http://dev.mysql.com/doc/mysql/en/mysqldump.html

If you don't have shell access to the Linux box, you will need to use
phpMyAdmin ( http://www.phpmyadmin.net/ )
to export SQL data, and then use mysql tool to execute the big query.
That's not a php question though, but :

Enjoy!