Tag: script

Debian: Auto Update System Daily without special Tools

If you want to have a full automatic Update on your System then open a Gnome Terminal / Linux Console run (# Comments): $sudo nano /root/update.sh enter: #/!bin/bash apt-get update #pull updates apt-get dist-upgrade -y # install updates apt-get clean #clean update database for next pull to have clean source urls exit 0 save with CTRL+X # save+Exit $sudo chmod 755 /root/update.sh # make able to run Setup Timeplan: $sudo su –  # change to root users console with environment $crontab -e  # open root timer enter: @daily sh /root/update.sh > /dev/null 2>&1 save with CTRL+X and be happy the […]

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 […]

Debian Ubuntu Update Script with Switch OFF after update

Problem: I f you work on you PC daily Patches must be checked and installed. At Debian / Ubuntu the Gnome-Update-Manager does this. But there is NO Shutdown possible after update. Solution: – create Script #sudo nano /root/upgrade-off.sh add inside: apt-get update           //for update Patches Database PC apt-get dist-upgrade -y         //install Patches automatic apt-get clean      //cleanup PC /sbin/init 0      //shutdown PC automatic or reboot Server = init 6 exit You can now after work set it to crontab or start manual by #sudo sh /root/upgrade-off.sh On Servers name it upgrade-reboot.sh and set root cron to run the job @hourly/@daily