Newbie guy needs help! Need to transfer my Db!


Read With Formatting | Free Open Source Tutorials Account

MySQL
Thread: Newbie guy needs help! Need to transfer my Db!


shrimpman
How can I transfer a Database in MySql from, let's say, my hard drive to another storage device.

Can someone help me with this? Thnx guys! :)

md_doc
The best way to do it is to use the program mysqldump which allows you to dump the database in the form of sql statements so that you can recreate the database. http://dev.mysql.com/doc/mysql/en/mysqldump.html has more information. You could also just copy the database files themselves but I would suggest doing the dump instead it is more reliable.