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: sustainability
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 […]
Ubuntu Debian: Replace Oracle OpenOffice with Free LibreOffice
Problem: Last weeks most of the free OpenOffice (Oracle owned) workers moves to the new free version LibreOffice http://www.documentfoundation.org Solution: To use free Software do: on 32bit: download files.. cd /tmp wget http://ftp5.gwdg.de/pub/tdf/libreoffice/testing/3.3.0-beta2/deb/x86/LibO_3.3.0_beta2_Linux_x86_install-deb_en-US.tar.gz wget http://ftp5.gwdg.de/pub/tdf/libreoffice/testing/3.3.0-beta2/deb/x86/LibO_3.3.0_beta2_Linux_x86_langpack-deb_de.tar.gz unpack.. tar -xzvf LibO_3.3.0_beta2_Linux_x86_install-deb_en-US.tar.gz tar -xzvf LibO_3.3.0_beta2_Linux_x86_langpack-deb_de.tar.gz go into file to install.. cd DEBS sudo dpkg -i *.deb sudo dpkg […]
Ubuntu Lucid Lynx 10.04: FireGL xorg.conf Thinkpad R50p
Problem: By default the xorg.conf FireGL 128MB radeon driver settings are slow settings Solution: to get a faster behavior do edit /etc/X11/xorg.conf (Update: use Driver “ati” for 3D, use “radeon” for better flashvideos) # sudo nano /etc/X11/xorg.conf and change radeon area to: Section "Device" VendorName "ATI Technologies Inc" BoardName "M10 NT [FireGL Mobility T2]" BusID […]
Centos 4.7 4.8 SME Server 7.4 7.5.1 LSI Megaraid ATA PERC 2 Driver (Dell Poweredge 600SC 1600SC)
For install of Centos 4.7 / 4.8 and SME Server 7.4 / 7.5.1 with Kernel 2.6.9-89.0.16.EL Kernel 2.6.9-89.0.16.ELsmp take my compiled Driver here and copy it to /lib/modules/2.6.9-89.0.16.ELsmp/kernel/drivers/scsi/megaraid look for only this modules, remove old or other! megaraid.ko (my compiled driver) megaraid_mm.ko megaraid_sas.ko edit with: #nano /etc/modprobe.conf change first line!!! to: alias scsi_hostadapter megaraid go: […]
Fast Debian Server as Live Ram Disk System
http://wiki.debian.org/LiveCD – to run a debian Server inside RAM you have to download debian live cd – to change keyboard layout from default US set bootoption at kernel bootkbd=es for example for spain or “de” for german – to change the user name set [CODE]username=user[/CODE] at bootoption – to fix the servername set [CODE]hostname=debian[/CODE] – […]
Change System Crypt Password Debian Ubuntu LVM Full Encrypted System
Solution: The new NEW Password must be set before you delete the old! – open Console! – Login as root! with #sudo -s – enter #cryptsetup -y luksAddKey /AddKey /dev/sdaX – System prompt for old Password, enter it now! – then enter new password min 8 Characters – System should show “Command Successful” – if […]
Light Fast Login Manager XDM with Wallpaper
Problem: If you install XDM as light Login Manager, cause XDM offers not reboot/shutdown without Logon Access, XDM is very grey. Solution: – create JPG with your Display-Size (1024×768) – save it at /usr/share/X11/image.jpg – edit #sudo nano /etc/X11/xdm/xsetup – add line: xsetbg -onroot -fullscreen /usr/share/X11/image.jpg – install #sudo apt-get install xloadimage ..enjoy xdm..