If you run a WordPress Blog or other CMS with MySQL Backend you can easy change one same word or expression on all content sites on the fly Do a mysqldump at first of the current database $ mysqldump -u username -p dbname > dbbackup.sql Login to the MySQL server Console Switch to the Database […]
FreeBSD: Monitor svn Updates
If you use the svn subversion tool to update source tree or ports tree, you want to have a possibility to look back what was pulled, pushed and droped you can use a Log File to monitor the update scripts. This helps if you temporarily log out the Terminal Sessions for a Coffee break. Howto: […]
FreeBSD: Current Version port upgrade fails with “portsnap extract” bug
If you use the current “head” Version (Release 12) of FreeBSD with a svn updated /usr/src path you could run into errors after updating the OS via buildworld from sources. There’s a bug ahead Revision “r314099” at the “portsnap” lib that will stop on extracting the ports.tgz to /usr/ports! Solution: Pull again sources to /usr/src […]
WordPress: Monitor the Size of the MYSQL Database
If you use WordPress or a other Blog Software with a MySQL Database over years it is useful to do some things regularly: Check the Database Size weekly, that no Skript Kid has found a Backdoor and fills up the Database silent Purge Database Caches with default maintenance tools of the Software Dont forget to […]
Centos: Release 5 now “end of life”
On 2017, March 31th the official Release End of Version 5 is reached. This also touches SME Server Version 8.1. If you use this you must now upgrade the Webserver to the next Version. Checkout which last version offers latest Options like PHP7, MYSQL 6 ..more Checkout that you current Content PHP Kits Support the […]
WordPress: Why less plugins is more?
WordPress is a well known Blogging Platform to publish your Content to the world. But after some years of analysing of my Webserver Logs i remarked that a lot of used plugins produces more errors on inside linking than i would like to have. I could not explain why the Search Engines run into Errors […]
WordPress: Change User Password manual on mysql prompt
If you don’t want to use Passwords generated by wordpress itself, you can do it manual on a MYSQL Console howto: Login to your Webserver with the Database via encrypted SSH!! Login to the MYSQL Server Conssole with $ mysql -u username -p Enter Password, and change database with mysql>use database-name-of-blog Now Set Password for […]
WordPress: SEO Ranking bad after setting “read more” tags
After some weeks of cleaning up my blog, i remarked a very bad ranking from under the first 10 on google to nirvana What did i change? saved wp-login with htaccess to non-public set post content with “read more” buttons Background: Search engine like google wasn’t able to pull content of posts which are cut […]