"zip" a mySQL (phpMyAdmin) database

Question

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

Answer 1

Yes, 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.