These are a bunch of helper Scripts which I frequently use.
This script Creates Backups from all MYSQL Databases where each Database is backedup into a separate SQL file.
Download File:
wget https://raw.githubusercontent.com/nourbakhsh/linux-helper-scripts/master/backup-all-db.sh
Insert your Parameter for:
BACKUP_DIRECTORY="$HOME/backups/$TIMESTAMP"
MYSQL_ROOT_USER="root"
MYSQL_PASSWORD="YOURMYSQLPASSWORD"
Makes it executable:
chmod +x backup-all-db.sh
Run:
./backup-all-db.sh
Import SQL Files:
gunzip < DATA-DUMP.sql.gz | mysql -u root -p DATABASE_NAME
Removes all Outdated Kernel files to get more freespace under Ubuntu
Download File:
wget https://raw.githubusercontent.com/nourbakhsh/linux-helper-scripts/master/removeOldKernels.sh
Makes it executable:
chmod +x removeOldKernels.sh
Run as root:
./removeOldKernels.sh