Q:

How to export WDPA dataset to text and shapefiles?

Please have some patience with me as I am not a GIS professional at all, I am merely trying to work with some of the file formats. Let me first explain what I am trying to accomplish:
The WDPA (World Database of Protected Areas) is, as the name says, an attempt to map all protected areas in the world, with an emphasis on biodiversity. Their work can be seen here:
http://www.protectedplanet.net/
You can browse all the areas right there on the site, search for them, etc. In addition, they have the following download options of the entire set (right below the search box):

CSV
KML
SHP
ESRI Web Service

This interests me greatly, since I want to integrate these protected areas into my own website, in the following ways:

Using Google maps, per country (so not all at once) show the polygons as overlay on the current Google Maps canvas (I have to stick with Google Maps here, due to other functionality)
Clicking on an area should show its metadata
Stretch goal: As my website is about photography, it would be incredible if a geotagged photo could automatically be associated with the protected area in which it was taken

To accomplish the above, I figure I need the following:

I need all textual metadata of all areas on the map in a way so that I can convert it into a format that is suitable for MySQL, the internal database I use. For example, each protected area has a unique ID and a country code, I need that data.
I need the shape data per protected area (or per country?). This is where I lack knowledge. Either way it needs to be in such a format so that it can be shown on Google Maps, and I need to know to which protected area (or country) it belongs

Some things I tried:
The first 3 download options provided by WDPA all seem the same, not sure if that is a bug on the site or not. I had no idea how to open them but eventually figured out I need ArcGIS and installed a trial version. I still don't know how to export anything in the format I desire though.
The 4th option seems most promising:
http://ec2-54-204-216-109.compute-1.amazonaws.com:6080/arcgis/rest/services/wdpa/wdpa/MapServer
There the entire set is offered via different web services. I tried opening the layer in Google Earth, but it keeps crashing on me, and I read you can't export layers from Google Earth? The other options are not familiar to me but after trying them I see no easy way to get the data I want in the way I want it.
I'm looking for your guidance in this question. This data set is a treasure and I am very excited to try to bring it into my own site, but I'm failing miserably at the first step.

A:

If you download the shapefile you will have what is necessasry to get started. The full file (all of the world) is around 2.9GB. The each feature (protected area) has attribute information about name, protected area type (ICUN standard), country code and more.
From here on you can do things two ways: 

Use a desktop tool to produce a kml-file which you place on your
server
Go the whole way uploading the file to a database and access
it from a server based map server

From what I gather the answer you are lookin for is this:

Download the shapefile
Open it in QGIS. QGIS is an open source tool which will allow you to do most spatial operations. It is definetively an alternative to ArcGIS if you are not intent on spending money on this project.
Filter it according to your needs
Add attributes like links to images or lists of images
Export the result to KML-file.
a) Place the KML-file on your server and point to it from your
website or 
b) upload it to google maps and embed one of those maps
on a web page on your server.

If you at some stage want to make things more complicated you move into MySQL territory. Upload the file using GDAL. FME is at commercial tool which will allow you to input a shapefile to MySQL. If you used PostGIS you could use the SPIT plugin which allows you to upload directly from QGIS.
Once your data is in MySQL you can add a map service using Geoserver, mapserver or others topresent the spatial data. Geoserver will provide data in a lot of formats suitable for inclusion in other systems. KML is one of the outputs.
You can set up your kmz request by following the relevant guidelines. Geoserver will allow filtering using attributes in the data set. 
With this I hope we have given you a basic way forward as well as information about how to move to the next level.

