There are lots of ways to get all IDs. Assuming you do want all posts – which include Posts, Pages, Media, Menu Items, custom post types, etc.:
phpMyAdmin:
Run a SQL query: SELECT ID FROM wp_posts
then export the results to whatever file type you prefer.
Related Posts:
- Get page ID of page that is set as the posts page
- Are post ID’s reliable?
- Get current post id in functions.php
- get all posts ID from a category
- Export WordPress Posts and Meta Information in CSV format
- Get the current post ID as a variable in Javascript
- Is post ID number always incremental n+
- how to get permalink using sql
- How can I export WordPress posts’ attachments?
- Are all ID’s used unique?
- $post->ID displays wrong ID
- At my posts archive page, outside the loop, get_the_id() returns the top most post’s ID
- How can I export and then import posts with featured images?
- Showing random content / pictures from earlier posts in a sticky post?
- Get the post_id of a new post
- get post id in while loops outputting page id
- How can I display a specific user’s first published post?
- Use Cron to modify posts via sql
- Undefined variable post_id in custom quick edit coloumn
- Exporting Data from WordPress into a flat table
- Sql syntax error
- get posts and postmetas in assoc array
- Importing New Posts from Live Site into Local Dev Site
- Export posts manually selected by end user (not logged in)
- Getting post id from wp_insert_post_data function?
- Does an article (post) id ever change?
- How to get the post’s parent ID?
- Can a page_id and a post_id be same?
- How much of my site can I recover from public_html?
- Is there a better, more efficient way to get the post id outside the loop?
- How do I find which articles are missing a featured image in The WordPress database?
- Getting current post ID in functions.php
- Buddypress activity id
- Bulk update post slugs through database
- Get the most repeated post contents from a search?
- Multiples Empty Posts were created and cannot delete them
- How blog page in WordPress works : blog page retrieve first post ID
- Delete WordPress posts from URL list sql query
- SQL query to retrieve all the records that have not indicated category
- Post-ID in url differs from $post->ID
- Why is my Blog Page ID == First Post ID?
- current post with current author
- Is it possible to change post id for an already added menu item in WordPress?
- How to verify wp user password by sql query in wp? [closed]
- How to get next post ID?
- Search results posts_orderby and ID
- WordPress Local And Live Site
- Overwrite posts/pages via import
- Retrieve post ID from “querying” URL
- How to get a post’s content? [closed]
- obtain the author id given the post id
- How to get ID of the page included with get_page()?
- How to I retrieve the ID from the Posts page?
- WordPress website loads more posts than expected
- Crazy Question – Updating Post ID
- SQL Command for restoring trashed comments
- Why I can not I use the variable outside my function?
- Importing posts only – consequences?
- retrieve the oldest post id
- How to Assign / Move all Deleted post to a category
- Migrate posts from category and sub-category via SQL
- Extract wordpress posts content and category content
- Bulk find & replace on WordPress posts/pages (minus image paths)
- Get post attachment with post id
- SQL query: select duplicate posts – but using duplicate meta [duplicate]
- WordPress MySQL Search and replace with wildcard?
- Using a meta_value or postdate to to query and orderby
- insert post fails after multiple postings
- Adding wordpress posts using phpmyadmin
- How can i take all ids from untrash_post action?
- How to run select query of post with category and tags?
- How do I apply a wordpress function to something with no ID inside an archive page?
- Get from the dashboard the ID of the current post being edited
- Only get post_id [duplicate]
- Surrogate ID for posts, is there an alternative field in the posts table?
- Is it possible to have dynamic post id # in add_menu_page()?
- Export Posts with specific custom fields by sql
- Query to get data of a post, if in category?
- Can’t create posts with WP DB Abstraction Plugin
- SQL query to remove first image in all posts
- Using Post ID and Page ID in same function
- Moving Posts to a new site and maintaining URLs
- Delete junk text from all the post using my sql command
- Special Query: Title, Terms, Content – %LIKE%
- unused post IDs
- Custom post page has attributes of latest post [closed]
- Can I get custom post items in select box (dropdown)
- If meta_key exists then don’t select this post?
- The page that displays Posts on homepage
- What is $post->ID
- Export Posts Without Categories In An XML File
- View post with specific category id and name which I selected in the backend (drop-down option)
- How to get post ID after removing that post?
- Change permalinks in posts via SQL
- Batch Scanning and Deleting Empty WordPress Posts
- How to get a list of all posts and their categories?
- How to speed up WP_Posts_List_Table __construct() Query on a wordpress website with over 1 million posts?
- SQL phpmyadmin remove posts from cat id exclude condition
- Why does ‘get_the_ID’ work outside of the loop?
- How do you export and import wordpress blog posts and exclude pagebuilder shortcodes?