WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been working with a client to redesign his site and we are at the stage where we are going live, except I'm running into a little problem. Time is of the essence, as the deadline is mid-day tomorrow.

Since I began working on the site, he sent me a database of posts from the beginning of time up until September 13, 2011. Now that we're going live with the new design, I need to update the posts in the new database from that day up until today so they don't get lost in the process.

I tried using WordPress' export feature, unfortunately there are far too many posts for it to allow me to even download the file. So what I want to do is use an SQL query to get these posts, and export a .sql file in phpMyAdmin.

Can anybody give me an example of how I would do this? Any help is appreciated, thanks.

share|improve this question

closed as off topic by EAMann Jan 18 '12 at 17:56

Questions on WordPress Development Stack Exchange are expected to relate to WordPress within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

Questions on this site should be about WordPress or WordPress administration. Generic SQL questions are better suited for Stack Overflow. – EAMann Jan 18 '12 at 17:56
up vote 1 down vote accepted

share|improve this answer
Even more simple than I thought, thanks! – Jared Jan 18 '12 at 11:17

Not the answer you're looking for? Browse other questions tagged or ask your own question.