Category: Wordpress Help

WordPress: Secure Faster Effective Blogging

If you use WordPress or a other CMS for daily blogging, it’s useful to have a own User Acount on a PC. Advantages: Own Browser for Blogging with saved Passwords Own Link Bar for quick switching between the Social Media Platforms You won’t need to open Security Holes like API Software Interfaces for used Plugins Speeds up the WordPress Blog cause reduced Plugin loads You have the full control. cause most free API Plugins save your Passwords on foreign Servers One touch Bookmarks let you jump fast between the Social Media Platforms No Data are automatic transfered without your knowledge […]

WordPress: Change Word on all content sites with mysql

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 mysql> use dbname; run command for tests, lists touched posts mysql> SELECT * FROM wp_posts WHERE (post_content LIKE '%expression%'); Run Replace code to pre, cause i use preformat text plugin for the copy & paste boxes mysql> UPDATE wp_posts SET post_content = REPLACE ( post_content, […]

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 create a MySQL Dump Backup weekly with cron To Check the Size login on mysql command prompt do: $mysql -u dbuser -p #Enter Password mysql > use dbwordpress mysql > SELECT table_schema "Data Base Name", sum( data_length + index_length) / 1024 / 1024 "Data Base […]

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 or dead ends if they scan via the bots the Content. I didn’t realize that the plugins were the bad factor. If you see same problems you can start up analyse your Blog for free with these steps: Go Plugins disable all uneeded Plugins like […]

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 the User mysql>UPDATE wp_users SET user_pass = MD5('NEWPASSWORD-16-DIGITS') WHERE user_login = "THEUSERNAME"; System shows Echo: mysql> ok.. Changed 1 Row.. Quit mysql> exit Logout of SSH

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 by “more” Search engine wasn’t able to pull relinks over the wp-admin url by the internal wordpress feeds I was forced to turn back my settings and wait for better ranking.. not safe but must be..