WordPress: Get URL of all Posts

On a lot of  Blogs, Forum and Howto Pages i have read the Question: „How to get the URL of all WordPress Posts?“

If you dont want to use a external Plugin which can be a Security Hole in the CMS you can fix it with a small Workaround:

  • Login into WordPress as Blog Admin
  • Create a New cenral Categorie like „Howtos“
  • Now go to the Posts Page where all Content Pages can be seen as list
  • Here SELECT ALL and do Bulk Action „ADD“ to the new Categorie „howto“

that’s it.. now all Posts listet like.. https://www.linuxonlinehelp.de/category/howto/

wordpress url of all posts blogroll
wordpress url of all posts blogroll

Remark:

  • If you create new posts, then do always add them to the Categorie „howto“

WordPress: Replace or Purge Text on all Posts by mysql

If you have to remove a link, text or else on all wordpress posts pages with same signs like the „read more“ tag do:

 mysql -u dbadmin -p 

– enter password
– change database by:

use databasename

– run change command(SET „more-tag-source-html-pre“ WordPress reformat the output here! ):

mysql > UPDATE wp_posts SET post_content = REPLACE (post_content,'<!!--more-->',''); 

– System Echo’s:

Query OK, 88 rows affected (0.01 sec)
Rows matched: 706 Changed: 88 Warnings: 0

WordPress MySQL: Cleanup old revisions old posts old entrys

Problem: If you use wordpress and edit often your posts a high count of old revisions are backuped inside the mysql database:

Solution:
Login mysql

$mysql -u root -p [Enter root password]

at mysql command line select wordpress your database
mysql>use wordpressdb; [Enter]
System echo=Database changed..

delete old backups of posts
mysql>DELETE FROM wp_posts WHERE post_type = "revision"; [Enter]
System echo=..Entry affected time..

logout database and revisit pages, if you have made a database backup with mysqldump before and after cleanup you see how much size the database lost (du -h wordpress.sql)
often 80% of the size.