Re: Syncing of Data
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 http://dev.mysql.com/doc/mysql/en/Replication.html Michael Mulley, Nikhil wrote: 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 * 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Syncing of Data
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]