..follow me on https://www.twitter.com/linuxonlinehelp

Tag: posts

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/ Remark: If […]

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.