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 […]
Category: Wordpress
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 […]
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 […]
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”