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:
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:
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.
select post_title, concat('http://www.techdoze.net/',post_name) from wp_posts where post_status='publish' and post_type='post';
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:
After choose the export file type and hit GO:
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.