How to copy & move MySQL database

The easiest way is probably by using phpMyAdmin, which is installed as part of XAMPP.


 

To export

 

STEP 1: In a browser, open http://localhost/phpmyadmin
STEP 2:Click on export

STEP 3:Select your database(s) from the list

STEP 4:Tick the save as file box at the bottom of the page.
Click Go

Your database(s) will be exported as an SQL file, which you can use to re-create them on your other machine. Copy this file to your laptop.


 

To import

 

STEP 1:In a browser, open http://localhost/phpmyadmin
STEP 2:Click on import

STEP 3:Browse to the file you just exported.

STEP 4:Click Go after selecting your file and you’re done.

Browse the Blog section for more such interesting posts

Leave a Reply

Your email address will not be published. Required fields are marked *