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. select post_title, concat('',post_name) from wp_posts where post_status='publish' and post_type='post' The SQL is exporting the published posts only in case you need all the posts you can remove the post_type. I have created a custom SQL with which I am exporting all my post titles and URL, you just need to modify the concat(‘’,post_name) with your site HTTP address. Step 3- Use the below SQL and hit GO and export Step 2- Choose the correct DB and move to SQL tabĪfter 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: You need to go in the hosting account and click on the PHPmyadmin: Steps to Export WordPress Posts URL’s and Titles Step 1- Open PHPmyadmin 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. 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. You may need the list in case you want to see all the articles and the url’s for them. In this tutorial I will show you how you can export your all WordPress articles with the URL’s in an text files.
0 kommentar(er)
