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 […]
Schlagwort: posts
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 = […]
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 […]