How to reset the post ID increment

I also happened to me once, I only had like 10 real post, so what I did was to go to phpMyAdmin, make sure your that on my wp_posts and wp_posts_meta tables are only information about the 10 real posts IDs, from the mysite/wp-admin/export.php I exported all the posts (10 of them), I run the following SQL query on phpMyAdmin. 

DELETE FROM wp_posts;
DELETE FROM wp_post_meta;

TRUNCATE TABLE wp_posts;
TRUNCATE TABLE wp_post_meta;

And finally, I import again the 10 posts, after that the ID was bad to normally, mine was only around 10000 tho, but it should work nonetheless.

Related Posts:

  1. Is it fine to have foreign key as primary key?
  2. Detecting errors generated by $wpdb->get_results()
  3. wpdb update add current timestamp not working
  4. Custom form that store input in database
  5. Restoring WordPress posts from database only
  6. Displaying content from one WP site on separate WP site
  7. Lost the `wp_options` table: what’s the best way to restore the site?
  8. Issue with wp_insert_post and post_content field error Could not update post in the database
  9. wp_posts – guid update
  10. Performance Gains of Relational DB Setup
  11. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  12. WordPress Database Charset/Collate
  13. store simple data in get_option()
  14. How might I retrieve a featured post image from an external WP site and display it as a link back?
  15. Why is Woocommerce writing in my wp_comment table?
  16. Error establishing a database connection when migrating site to localhost
  17. How to implement content from external database into WordPress text page? [closed]
  18. Strange Deadlock database error for the query “Delete From wp_options”
  19. Strange characters on wordpress site – Not UTF8 Issue
  20. WordPress showing install screen after max_questions error
  21. Connect to live db whilst working locally
  22. Storing textbox values in Database
  23. WooCommerce – Query for ordered products
  24. Is a direct or import approach safer for migration into WordPress?
  25. Query WordPress database by registered date and role
  26. Tons of Twitter rows in my database
  27. Why can’t I swap a DB in a WP install? [closed]
  28. How to replace values in WordPress DB using phpMyAdmin
  29. How do I reset a self-hosted WordPress URL?
  30. One post carries 30 postmeta values, is this too much?
  31. Show content from database
  32. Customize JSON output
  33. What happens if I overwrite the current wp_options table with a backup from a week ago?
  34. CRUD operations using WordPress database API
  35. Display SQL that wordpress is running
  36. Critical error in final stage of website launch – URLs are BROKEN!
  37. change wp user status from wp_users table
  38. How to resolve Connections using insecure transport are prohibited while –require_secure_transport=ON
  39. How to Mirror WordPress database from Remote server to Local server
  40. Difficulty importing my live site to local
  41. WordPress returns to an old version
  42. data (html) migration to posts
  43. Super slow queries from author archive pages killing my database
  44. localize elements in database
  45. Use same database on main domain & sub domain
  46. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  47. Get value form wordpress database
  48. Moving to another server database connection error [closed]
  49. Why user_pass column in wp_users table is varchar(64)
  50. Best practice to limit results in get_row()?
  51. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  52. Connect to another WP install and grab post based on custom field
  53. Which table (and column) has the content of configured get_post_meta?
  54. Serialize data before inserting into the DB
  55. Reinstalling wordpress from database breaks the site
  56. Pages from custom table
  57. Trouble running $wpdb->query() with last_insert_id
  58. Using $wpdb | checking entered email against existing emails in db
  59. content disappearing minutes after it’s published
  60. What is the most efficient way to reset a WordPress site?
  61. wp-cli: Error establishing a database connection: undefined constant DB_USER
  62. Optimizing function that automatically creates internal links based on post title string
  63. Can I customised default WP table
  64. Woocommerce – Check product stock availability from external database
  65. Get results from wordpress data custom table
  66. Outputting query results
  67. Help With a Large WordPress Based MySQL Database on Shared Hosting
  68. WordPress where clauses in db select
  69. How to display data from db in select list [closed]
  70. Will adding & modifying default WordPress table index break future WordPress update
  71. Database migration issues – Error #1046 No database selected
  72. echo site_url() returns a different value than what is in the database siteurl field
  73. Search Character Set Problem
  74. Native timestamp on wp_options option
  75. _wp_attachment_metadata is not being added to database when PDF files uploaded
  76. SELECT rows between two datetimes when the range is dynamic [closed]
  77. How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
  78. How to fix Uploaded to this post option to see group of images uploaded to a post?
  79. How to access a table in a wordpress database using REST API?
  80. error establishing a database connection 3
  81. How to edit posts/pages without making the change live?
  82. Correct and secure way to access a custom SQL database in a custom PHP template file
  83. Does WordPress Support Using Named Pipes on the Windows Operating System?
  84. Missing latest posts and options after DB migration via phpMyAdmin
  85. get_the_terms is not working
  86. Custom metabox does not store data
  87. wordpress database error
  88. How do i get value from wp_postmeta?
  89. Local host to server import problem
  90. Restoring .sql backup results in “Error establishing a database connection”
  91. Link to handle $_GET request
  92. WordPress sync with phpbb
  93. “MySQL server has gone away” since update to 3.8
  94. featured image not showing up with mysql_connect
  95. Getting deleted users in database
  96. Options of accessing wordpress data from mobile app
  97. Getting data from a table using a query
  98. Database interaction (private-public) [closed]
  99. WP Multisite Users Not Linking
  100. Query a meta key using an array of values where the database value is a string

Leave a Comment

techhipbettruvabetnorabahisbahis forumuedueduedueduseduedueduseduedusedus