Many times we want to shift our database from one machine to another. I faced similar situation when I want to shift my database from external server to my own. While shifting , I was using ubuntu operating system and mysql query browser as a tool. Though, it is pretty easy but I think it would be useful information for you.
Step 1 . Open Mysql Query Browser
Step2. Right click in Schemeta Option and select create Schema
Step3. Put your database name
Step4. Now Click on File(Alt + F) and select open script
Step5. Select script which you want to import and click on execute.
Its done!
I Hope that helped
