Hi List,
I have a MySQL Data running on one Linux Server in my Intranet ,
I would like to have all the Databases and tables synced to MySQL Server
running on Windows Server .
How to Sync the data , or just copy the table from one machine to another
machine.
Does MySQL have any * Export
Depending on your needs, you have several options, all documented in the manual:
SELECT ... INTO OUTFILE http://dev.mysql.com/doc/mysql/en/SELECT.html
mysqldump http://dev.mysql.com/doc/mysql/en/mysqldump.html
http://dev.mysql.com/doc/mysql/en/Upgrading-to-arch.html
Replication
Hello.
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected
rows to a file. And LOAD DATA INFILE. See:
http://dev.mysql.com/doc/mysql/en/SELECT.html
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Also you may use mysqldump utility. See: