Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to copy table and data to another computer?

 
Elahe Shafie
Ranch Hand
Posts: 291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Tina Coleman
Ranch Hand
Posts: 150
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Elahe Shafie
Ranch Hand
Posts: 291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
http://www.mysql.com/doc/R/e/Replication.html
Hope this explains it well enough.
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic