Title: Database Export
Last modified: July 31, 2018

---

# Database Export

 *  Resolved [rachelove](https://wordpress.org/support/users/rachelove/)
 * (@rachelove)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/database-export-2/)
 * Hi there, how might I export placemark points? Or please point me to the db table
   they exist in, having trouble finding them 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Nagmay](https://wordpress.org/support/users/gabrielmcgovern/)
 * (@gabrielmcgovern)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/database-export-2/#post-10552892)
 * Placemarks are a custom post type that utilize a bunch of metadata.
 * To export you could:
    - Get the ID from wp_posts
    - Get the data from wp_postmeta where post_id=ID
 * Each meta_key starts with “placemarks-“. For instance “placemarks-lat”.
 *  Plugin Author [Nagmay](https://wordpress.org/support/users/gabrielmcgovern/)
 * (@gabrielmcgovern)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/database-export-2/#post-10552899)
 * Or… I just realized that you can use the default WordPress exporter.
    Tools >
   Export and choose placemarks.
 * This will spit out XML like:
 *     ```
       ...
       	        <wp:postmeta>
       			<wp:meta_key><![CDATA[placemarks-lat]]></wp:meta_key>
       			<wp:meta_value><![CDATA[45.43715546770171]]></wp:meta_value>
       		</wp:postmeta>
       		<wp:postmeta>
       			<wp:meta_key><![CDATA[placemarks-lng]]></wp:meta_key>
       			<wp:meta_value><![CDATA[-122.73131936789241]]></wp:meta_value>
       		</wp:postmeta>
       ```
   
 *  Thread Starter [rachelove](https://wordpress.org/support/users/rachelove/)
 * (@rachelove)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/database-export-2/#post-10552914)
 * Sweet! Thx for your help 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database Export’ is closed to new replies.

 * ![](https://ps.w.org/placemarks/assets/icon-256x256.png?rev=1625338)
 * [Placemarks](https://wordpress.org/plugins/placemarks/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/placemarks/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/placemarks/)
 * [Active Topics](https://wordpress.org/support/plugin/placemarks/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/placemarks/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/placemarks/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [rachelove](https://wordpress.org/support/users/rachelove/)
 * Last activity: [7 years, 10 months ago](https://wordpress.org/support/topic/database-export-2/#post-10552914)
 * Status: resolved