If you use WordPress and have tested some plugins and removed them later, it is possible that you have much waste tables still inside your database. First do Database Backup with MySQL DUMP Then check it enter the mysql console as your mysql admin user and do: $mysql -u mysqladminusername -p mysql > use databasename; mysql > show tables; System echo: +—————————+ | Tables_in_wordpressdatab | +—————————+ | wp_commentmeta | | wp_comments | | wp_links | | wp_options | | wp_postmeta | | wp_posts | | wp_term_relationships | | wp_term_taxonomy | | wp_termmeta | | wp_terms | | wp_usermeta | | […]
Tag: wordpress
WordPress: Prevent Copyright Violation
If you are a Hobby Blogger like me, you should ALWAYS take Snapshots for your Blog with your OWN Camera! For “non professional” use you can take the cheapest Camera or reuse old Smartphones of the Family. Resolution at VGA Mode (640×480/800×600 less 250kb) is more enough than you need. Faster you can’t save or earn Money, a Camera Snapshot needs less a second.. Don’t DO Rules: Don’t download and share Images from public sites Don’t take Snapshots on public Sites with a Snapshot Tool like gnome-screenshot Don’t take Parts of Images from public sites Don’t trust free Image Pools!! Most […]
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..
WordPress: Move Blog to new URL Domain HTTP HTTPS on the MYSQL Console
Info: Today most Search Engines prefer Blogs who are offering “HTTPS” at the URL for secure direct connects to the Websites but this results a lot of headaches to the Website Developers. To be effective you should know: You have to offer HTTPS beside HTTP You should use a validated Domain Certificate, most Domain Resellers offer them for FREE You should know that NOT every FREE Certificate is TRUSTED by every Browser (green closed lock symbol at the adressbar) You have to Develop Websites WITH variable Format output ( PC, Tablet, Smartphone, Smart-TV, Infoboxes,) Design Websites and test 3:2, 4:3, […]
WordPress: RSS Widget Bug builtin Widget (class-wp-widget-rss.php)
Details: If you enable the basic builtin RSS Widget Module and set the RSS Feed URL like http://www.domainname.com/feed/ the widget set the URL only on the little “RSS Icon” but NOT on the RSS Hyperlink ! The Hyperlink is pulling the Value of $url (www.domainname.com) but not adding “/feed/” subdir value. Solution: go ../wp-includes/widgets/ edit with $nano class-wp-widget-rss.php go line 81 show title “rsswidget” href ” ‘ . esc_url ( $link ) . #change here $link to $url exit and save.. check results..
WordPress: Change Editor Font Size without Plugins
Problem: If you use wordpress and use a high resolution Screen on your Laptop or Workstation the dehault font size is too small. Solution: Edit with: #sudo nano ../wp-includes/js/tinymce/themes/advanced/skins/wp_theme/content.css change value 13 to 16 or 19 at: body { font: 16px/19px Georgia, "Times New Roman", "Bitstream Charter", Times, serif; margin: 10px; color: #000; }
MySQL : Backup and Restore Database without phpmyadmin (commandline)
Problem: phpmyadmin interfaces are slow and often attacked by script kids, if you can don’t use it! Solution: To backup and restore use command line To Backup a database: $mysqldump -u root -p wordpressdb > /backups/wordpressdb-dump.sql [Enter root password] To restore: $mysql -u root -p wordpressdb < /backups/wordpressdb-dump.sql[Enter root password] Remark: this is not recogized by the ONLINE SYSTEM if users visits you pages to read! There must be no shutdown of the mysql or apache webserver, its a online HOT-Dump. If you like put it into a script and set cron to backup every night. Sample Bash MySQL Script […]
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.
Simple Protect WordPress Blog Server against Hacking
Simple Protect WordPress and own Apache2 Webserver go into WordPress Installation Folder edit wp-config.php and add line [CODE]define(‘FORCE_SSL_ADMIN’, true);[/CODE] save and close if you control your own Server and DSL Router disable Port 443 Access from Internet now http://mydomain.com/wp-admin is not reachable from Internet login to WordPress-Blog as Admin create new Adminuseer Named “mynewadmin” and relogin as mynewadmin delete default admin account, first set him to reader then delete the admin account if you use phpmyadmin on debian go to apache2 folder /etc/ and change alias from “alias phpmyadmin” to alias “safe123admin”,restart apache2, now phpmyadmin as http://mydomain.com/safe123admin/ Use only Plugins […]
WordPress Bug 2.9 “Your attempt to edit this post:”
Problem: After upgrade to Version 2.9 of WordPress on PHP4 Posts are saved as Draft Error: Message = Your attempt to edit this post: Solution: Install Plugin WP CMS Post Control http://wordpress.org/extend/plugins/wp-cms-post-control/ go Settings Post Control Core disable “Autosave”