How to import database using Mysql query browser in ubuntu?

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

No comments:

Post a Comment