I've created a large database on my local WAMP webserver.
I would like to send that database with all tables and table data to another computer.
Is this possible?
- mySQL ver: 5.5.15
- PHP ver: 5.3.8
- Apache ver: 2.2.21
Thanks
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityYes, if you use phpMyAdmin on your WAMP server, you can use the Export tab to dump your database and all the data in it.
On the Export tab, choose the Custom export method. This opens a bunch of options. Under Save Output to a File, choose Compression and you get to choose zipped from a drop-down.
Then you can Import that zip to another MySQL instance on another computer.
7zip
or any other archiver.