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

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
Share This