Title: Export permalinks from database
Last modified: August 19, 2016

---

# Export permalinks from database

 *  [rollotamasi](https://wordpress.org/support/users/rollotamasi/)
 * (@rollotamasi)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/export-permalinks-from-database/)
 * Hi guys,
    Is there any quick way, preferably via a SQL command which I can enter
   into PHPMyAdmin, which will export EVERY permalink from the database? If I published
   a blog post in four different categories then I would require all four different
   permalinks to be included in the exported list (this of course also includes 
   archives and whatnot).
 * Any help is much appreciated.

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

 *  [haochi](https://wordpress.org/support/users/haochi/)
 * (@haochi)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/export-permalinks-from-database/#post-739738)
 * SQL: `SELECT guid FROM wp_posts WHERE 1=1`
    You can then export the results by
   clicking on the “Export” link on the (very) bottom of the result page.
 *  [seedpxwee5](https://wordpress.org/support/users/seedpxwee5/)
 * (@seedpxwee5)
 * [17 years, 6 months ago](https://wordpress.org/support/topic/export-permalinks-from-database/#post-740215)
 * But those are the ugly permalinks.
    How do you convert them into pretty permalinks?

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

The topic ‘Export permalinks from database’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [seedpxwee5](https://wordpress.org/support/users/seedpxwee5/)
 * Last activity: [17 years, 6 months ago](https://wordpress.org/support/topic/export-permalinks-from-database/#post-740215)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics