Translation of "Appendix. Methods of copying and moving of MySQL databases." of "Methods for searching errors in SQL application" just published
By Sveta Smirnova-Oracle on Oct 13, 2010
Translation of appendix about methods of copying and moving MySQL databases just published. This is just short overview of possible methods and does not pretend to be detailed guide. It starts as:
Appendix. Methods of copying and moving of MySQL databases.
In this application I'd like to shortly discuss general methods of backup and moving of mySQL databases.
Easier and recommended way of data moving is mysqldump utility. You can copy data with help of following command: