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'm trying to do the same as this post. But I have a problem with the

insert records into your wp_users table containing all the ID's of the members you want to import

Right now, I have 3 members with respectively ID 1, 11 and 12. But I need to insert 500 users, with ID from 2 to 502. How do I create these ID line in my database without creating one by one ? Right now, I know how to add one at a time, but it starts at id 510 (because I've deleted older users). I want to start at ID 2...

Thanks a lot !


share|improve this question
The post you found appears to answer your question. Why do the answers there not work for you? – s_ha_dum Apr 23 '13 at 13:41
He doesn't explain how to create the X fake users to have the ID's created :( – cedric_charles Apr 23 '13 at 14:46
Well, where are your new users coming from? Another database? A CSV file? What? You can't restart at 2 without considerable difficulty, by the way, because you already have users with IDs higher than that, and what is the point? It is just an identifier. It can be anything. – s_ha_dum Apr 23 '13 at 15:13
The projects was done in Ruby on rails. Now we are making it with Wordpress. The database is coming from the Ruby project. So I have users related to some posts. I need to keep the good ID for a users to keep the link betweens post and users. So my users are in a CSV file. Why is that a problem to start back to ID 2 ? – cedric_charles Apr 23 '13 at 15:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.