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: http://dev.mysql.com/doc/mysql/en/mysqldump.html Be aware of case-sensivity problem: http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html >i 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 * Queries to export the data from the Table ( > MySQL running > on Linux ) into a small file and later using that that file , can we load > the data from > the file into the table in MySQL running on Windows. > > If yes, can you tell me how please. > > Thanks, > Nikhil."Mulley, Nikhil" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]