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;
}


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 for full automatic dumps:

#!/bin/bash
## automatic dump database and add time and date stamp ##
date=`date +%d%m%Y-%H%M` # set current date value
mysqldump wordpressdb > /backups/wordpressdb-$date.sql # save+date
exit # close script after work

To save all Databases on one MySQL-Server change

mysqldump --all-databases > /backups/server-all-$date.sql

now run

#crontab -e

set time to run:

@daily sh /scriptpath/backup-databases.sh > /dev/null 2>&1

This runs daily backup at 00:00AM and post no message to Admin (root) if you need mails remove (>…1)

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 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 you really need remove unneeded to be safe an fast!

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”

Warning: If you update WordPress to 2.6.1 your Blog is hidden for Google Bots and unlisted at Google Search !! Wait for Solutions !! MANY people have this problem.

Oeffnen Sie als Admin die WordPress Verwaltung und editieren style.css . Dort die Stellen mit dem Zeilenbeginn code suchen (mehrfach moeglich) jetzt koennen Sie die Farbe im HEX Code anpassen Blau=#0000FF

---

To change the command color, open the admin web interface of wordpress and edit style.css. Seach “code” lines and change the hex code of the entry

Um in WordPress Linux Kommandos oder Formeln einzugeben muss man die Option “Code” benutzen. Damit wird das Kommando unformatiert dargestellt.

apt-get remove paketname – -purge sollte man so schreiben <code>apt-get remove paketname – -purge</code>

sieht dann so aus: apt-get remove paketname --purge

---

To view linux commands or formula in wordpress use the option “code”, shown above

Wie bei vielen heutigen Programmen telefoniert WordPress unerlaubt nach Hause, dadurch besteht die Gefahr das unerwuenscht Daten uebermittelt werden.
Um dies zu verhindern muessen Sie zwei Plugins herunterladen und in Ihren Plugin Ordner ablegen. Danach diesen Schutz unter WordPress-Admin->Plugins einschalten.

---

Plugins:

http://wordpress.org/extend/plugins/disable-wordpress-core-update/

http://wordpress.org/extend/plugins/disable-wordpress-plugin-updates/

---

WordPress-Software sent always informations about your site to wordpress.org to disable this download plugins (url-above) and activate them in your Admin-Plugin-Site.

Als ich heute unter verschiedenen Browsern meine neue Seite testete bemerkte ich das die Aufzaehlungen (“ordered list” Funktion Numerisch/Punkt) unter Internet Explorer nicht dargestellt wurde.

Nach der Recherche im Internet hatten viele User das Problem.

Eine Loesung fand ich im Portal selfhtml, da Microsoft wiedermal fehlerhaft ist.

Also unter wordpress -> Presentation->Theme-Editor die Datei Style.css oeffen und den Eintrag suchen:

.entry ol li {
margin: 0;
list-style-image: url(tux.jpg);  #X
padding: 0;
}

#X Diese Zeile einfuegen und in das wordpress >>Theme<< “Default “Verzeichnis eine Datei Namens tux.jpg legen (Tip Groesse 10x10pixel oder testen), danach koennen Sie die “numerische” Aufzaehlung in Ihrem Betraegen nutzen

geniessen Sie unsern kleinen Freund…..

---

Hello today i checked my site in different browsers and recognized the bug with lost format of “ordered list” (disk/numbers) in my page.
I searched on net for help, cause many people have this problem with the buggy IE7.
To solve it go wordpress -> Presentation->Theme-Editor to file Style.css and look there for lines above (mark = #X)
Insert the line with tux.jpg and upload a imagefile in size 10x10pixels.And now use in your posts the “numeric” ordered butten, it will be overlayed with the image. 

enjoy our loved little friend…