How to resort my id in wordpress?

I’m not sure what your intension is in doing this, but there are a couple of very important things to consider here

  • Revisions, drafts, menus, custom post type and attachments are saved in the wp_posts table, not only post post type posts, so you will never have two posts having ID’s which difference is 1

  • Not all postdata is saved in the wp_posts table. WordPress uses the wp_postmeta table to save information about attachments belonging to posts, save custom fields, save info about templates (for page post type) etc. There is also the wp_term_relationships table which is used to establish a relationship between posts and its terms assigned to them. In all cases, WordPress uses the post ID to establish relationships between items in the wp_posts and these two other db tables. Changing post ID’s in wp_posts breaks all these relationships

  • MYSQL databases has a huge maximum ID integer, which you will in all probabilty never fill. For a full break up on this, please see this post on SO

To conclude, if you don’t have a back up of your database, you are in all probabilty stuffed. As WordPress uses post ID’s to establish relationships, and you have changed the post ID’s, the only reliable method to do re-establish relationships will be to do this manually. I cannot see any other reliable method doing this

If you really need to change post ID’s, the best option will be to use a function like wp_update_postand writing a wrapper function to do what you need. This is quite expensive operations, so you will probably time out or exhaust memory on a huge database, so you will need to break your operation up into manageable chunks and run the function a couple of times.

Related Posts:

  1. visually sort ordering “custom post types” for end users
  2. Custom Table Column Sortable by Taxonomy Query
  3. How do I allow users to sort posts? [duplicate]
  4. Sorting results from JSON-API on custom fields
  5. Sort users in get_users() in custom order
  6. Sort by custom field value
  7. How to sort posts with the first 2 or 3 by latest, and the rest is random?
  8. Get “wp_get_nav_menu_items” to sort alphabetically [duplicate]
  9. Ascending sort order for monthly & category view, i.e. ?m=201204, ?cat=4
  10. Adding Sorting to Website?
  11. Sorting by tag or category
  12. get_terms orderby name as numbers
  13. Creating a category page by alphabet
  14. Sorting get_post_ancestors array
  15. wordpress custom_meta ordering of timestamps
  16. Multi-level ordering in WordPress
  17. Sorting for custom column in WordPress admin post table
  18. Help alphabetically sorting $terms from get terms(‘wpsc_product_category’
  19. Vertical alphabetically post columns
  20. Advanced custom fields sort repeater by date
  21. Displaying posts sorting by a custom criterion
  22. Sorting custom post type by usermeta
  23. Sort posts by meta key that is serialised with other meta keys
  24. orderby field – list of available options?
  25. User Query sort on custom field then name
  26. WP Query sort by meta value
  27. Best Practices for a Completely Customizable Homepage – without plugins
  28. Sorting posts by custom field value
  29. How do I create a sort capability by Title, Category, Author, Date?
  30. How to avoid duplicating same meta_value?
  31. Sorting/Filter posts from front-end in WordPress blog
  32. ‘sort_column’ => ‘menu_order’ not working
  33. Sort scheduled posts in ascending order by default
  34. How to sort by number
  35. sort items by randomness
  36. inner foreach loop sorting
  37. Sortby parameter to sort users
  38. Update meta_key value for a page
  39. Sort my event calendar by date
  40. Table Sorter sort by span title?
  41. make two custom columns sortables
  42. How to display remaining post ( in post__in ) if posts are less then post per page?
  43. ACF pro: Group teaser by datepicker year and display custom sub fields [closed]
  44. Sorting in WP_List_Table class
  45. Sort an array with an ACF meta key
  46. display wordpress user who published a pending post of another user
  47. Static front page and orderby
  48. Advanced sorting of content in wordpress [closed]
  49. Sort posts by first content letter
  50. Grouping posts starting with same letter
  51. Getshopped (WP-e-commerce): show all protucts on one admin page for drag-and-drop ordering [closed]
  52. List CPT by menu_order with children right after parent
  53. Multidimensional array sort?
  54. How can users sort multiple pages?
  55. How do i Sort my Posts
  56. Sort pages in loop by admin’s page attributes order field?
  57. ORDER BY custom field value
  58. Sorting: custom query with orderby meta_value_num THEN by title
  59. register_post_type sort order by title by default
  60. Sort custom post type list table by display name of a user id stored as post meta value
  61. Setting Custom Sort Order of Posts within a Category
  62. Sort plugins by rating
  63. sortable custom column in media library
  64. Can I force a metabox to be in one column?
  65. Sortable admin columns, when data isn’t coming from post_meta
  66. Custom Taxonomy Template Post List with Sort Order
  67. Custom Post type sort order not working in the admin area
  68. Custom taxonomy list and sortby letter pagination problem
  69. Advanced orderby with multiple meta_query
  70. How to use WP default post list tables in a plugin?
  71. Sorting meta_value as integer doesn’t work
  72. Exclude posts with specific meta_value while sorting by a separate meta_value
  73. How to add new tab to admin list of posts and handle result list
  74. How to re-order pages en-masse
  75. Sorting posts by multiple values, combined
  76. Sort by posts that have a featured image?
  77. Server-side sorting of posts
  78. Order By Post Type ThenBy Taxonomy
  79. Sorting custom post type columns with external data and without meta values
  80. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  81. Advanced search by two criteria – sort by location and date (ascending or descending)
  82. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  83. WordPress Comments sort by custom meta key
  84. How to sort posts in a custom post type by title in ascending order by default?
  85. Custom post type sorting: alphabetical order
  86. Sort Custom Post Type by Category ID then Post Name
  87. Sortable column containing numeric values for Custom Post Type at WordPress Backend
  88. WP_Query, Taxonomy, list of attached items to a Term, sorted
  89. Customize the Sorting Dropdown in WooCommerce use another list or more page
  90. WP Query with meta queries
  91. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  92. Woocommerce Category Sort Dropdown
  93. Multiple sorting criteries (order by)
  94. Ignoring ‘a’ when sorting posts
  95. Group & Sort Taxonomy terms by letter – Is there a better way?
  96. Custom post type taxonomy not sorting correctly
  97. sort custom post type by display name
  98. Sort author list alphabetically
  99. Woocommerce backend sorting product drag drop by menu_order to date
  100. Sort by multiple columns using get_posts
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedueduedusedusedusedusedusedusedus