How To Export All My WordPress Posts URL’s and Titles?

In this tutorial I will show you how you can export your all WordPress articles with the URL’s in an text files.  You may need the list in case you want to see all the articles and the url’s for them. For example I needed the list when I was using WooComerce and I wanted to export all the products for some price aggregates from my country.

In this tutorial I will show you how an list with the post and URL’s can be obtained,  what you need is only access to the DB with phpmyadmin, tool used by all the hosting providers.

Steps to Export WordPress Posts URL’s and Titles

Step 1- Open PHPmyadmin

You need to go in the hosting account and click on the PHPmyadmin:

PHP my admin

 

Step 2- Choose the correct DB and move to SQL tab

After PHPmyadmin has been opened you just need to go to the database from where the posts should be exported, just like in the below picture:

sqltab

 

Step 3- Use the below SQL and hit GO and export

I have created a custom SQL with which I am exporting all my post titles and URL, you just need to modify the concat(‘http://www.techdoze.net/’,post_name) with your site HTTP address. The SQL is exporting the published posts only in case you need all the posts you can remove the post_type.


sql_goPNG

In Delimiter box you can choose how the rows to be delimited, I let the default way but you can change it as you like.

Step 4- Export the file

After you are hitting the GO button a list with all the post titles and URL’s would appear and you need to hit export button:

export

After choose the export file type and hit GO:

choose format

 

This is all the steps that needs to be done to have the WordPress list with all the posts titles and URL’s, this is very easy to be done and you don’t need any plugin to do this. In case you have questions please let me know.

 

JOIN OUR NEWSLETTER
Join over 500 visitors who are receiving our newsletter and learn how to optimize your blog for search engines, find free traffic, and monetize your website.
We hate spam. Your email address will not be sold or shared with anyone else.