Title: Extracting *all* posts from SQL
Last modified: August 20, 2016

---

# Extracting *all* posts from SQL

 *  [SocialMedia4Dentist](https://wordpress.org/support/users/socialmedia4dentist/)
 * (@socialmedia4dentist)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/extracting-all-posts-from-sql/)
 * Is there a way to extract **all** posts from wordpress_db.sql?
 * I’m trying to import them into v3.4.1

Viewing 1 replies (of 1 total)

 *  [Andrew Bartel](https://wordpress.org/support/users/andrew-bartel/)
 * (@andrew-bartel)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/extracting-all-posts-from-sql/#post-2920495)
 * From an actual .sql file? You’ll have to import it into a database first.
 * Then SELECT * FROM (db prefix)posts will get you all of them.
 * Careful.

Viewing 1 replies (of 1 total)

The topic ‘Extracting *all* posts from SQL’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [upgrading](https://wordpress.org/support/topic-tag/upgrading/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Andrew Bartel](https://wordpress.org/support/users/andrew-bartel/)
 * Last activity: [13 years, 10 months ago](https://wordpress.org/support/topic/extracting-all-posts-from-sql/#post-2920495)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics