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

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

Post by Pratchay » Fri, 10 Feb 2006 15:25:55


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 want to make transfer data between MySQL Server to MySQL Local .

Post by Drakaz » Fri, 10 Feb 2006 18:39:35

With MySQL there always comes a mysqldump tool.

http://www.yqcomputer.com/
http://www.yqcomputer.com/

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

Enjoy!