Dear Friends, it is asked me to transfer tables and data to another computer with replication in Mysql and I have no idea how can I do that I have to finish it by tomorrow could please help me on this, since I am totally lost... Many thanks, Elahe
Try using mysqldump (a command-line utility available with mySQL). More info about it and its various options is at http://www.mysql.com/doc/m/y/mysqldump.html, but it will allow you to transfer table structure and data. Essentially, it creates the SQL statements necessary to rebuild the database and data on another server (could be mySQL, could be another database server).
Joined: Dec 12, 2001
Thank you so much Tina. By the way still I don't know what does replication do in terms of transfer table and data? any idea? Thanks, Elahe