How to backup multiple Mysql databases and automatically delete

The script below was adapted from iHRIS Backups (http://wiki.ihris.org/wiki/Backups) which was designed to backup one database. The script below will backup all databases in Mysql.

There is the option to remove database backup files older than 7days except from the first day of the month.

#!/bin/sh

MHOST=localhost

MUSER=db_username

MPASS=db_password

BACKUPDIR=/db/backup/dir

MYSQL="$(which mysql)"

MYSQLDUMP="$(which mysqldump)"

SUFFIX=`date +%F`

cd $BACKUPDIR

echo "Run MySQL backup"

DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"

for db in $DBS

do

    $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db > backup_${db}_${SUFFIX}.sql

    bzip2 -f backup_${db}_${SUFFIX}.sql

done

## Uncomment the following line to remove backup files older than 7 days except from the first day of the month.

#find $BACKUPDIR -name "backup_*.sql.bz2" -mtime +7 -not -name "backup_*-01.sql.bz2" -exec rm {} \;

Save the file, and ensure the script is executable using the command chmod a+x newfile.

MySQL Databases - Commandline Backup and Restore

• Backup A Single Database
  mysqldump -u root -p dbname > dbname.sql
  
  Where:
  dbname     = is the name of the database to backup
  dbname.sql = is the name of the backup file, can also be location of backup file
  
  
• Restore A Single Database
  mysqldump -u root -p dbname < dbname.sql
  
• Backup All Databases
  mysqldump -u root -p --all-databases > All-dbname.sql
• Restore Single Database from All Database Backup
  mysql -u root -p --one-database dbname < All-dbname.sql
  
  

Perl warning Setting locale failed in Ubuntu

Perl Locale Warning.
The warnings could be irritating, especially when installing any application. The warnings are also visible when some commands are run

The warnings look like:
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_ALL to default locale: No such file or directory
 
and when you run Run locale from the commandline

bonkhi@sparda-coven:$ locale

locale: Cannot set LC_ALL to default locale: No such file or directory

LANG=en_US.UTF-8

LANGUAGE=

LC_CTYPE="en_US.UTF-8"

LC_NUMERIC=en_NG.UTF-8

LC_TIME=en_NG.UTF-8

LC_COLLATE="en_US.UTF-8"

LC_MONETARY=en_NG.UTF-8

LC_MESSAGES="en_US.UTF-8"

LC_PAPER=en_NG.UTF-8

LC_NAME=en_NG.UTF-8

LC_ADDRESS=en_NG.UTF-8

LC_TELEPHONE=en_NG.UTF-8

LC_MEASUREMENT=en_NG.UTF-8

LC_IDENTIFICATION=en_NG.UTF-8

LC_ALL=

To solve this, generate the missing locale

locale-gen en_US.UTF-8

Set the missing locale

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales

How do you reset the circuit protection on Yamaha RX-v373?

Yamaha RX-V373 AV receiver's protection circuity is activated when there is fluctuation in power three (3) consecutive times. This protection mode disables the capability to "turn on" the device.

To disable this:

Hold "Info + Tone Control + Straight" for at least five seconds, while still holding, press the "Power" button.

Manually reboot the AVR for normal operation.

Using Php 5.3 on Cpanel platform

To install applications that require a higher PHP version, create a .htaccess file inside the application directory and specify which version of php you want used.


# Use PHP 5.3
AddType application/x-httpd-php53 .php

SSH permission issue - failed to add host to known hosts (/home/username/.ssh/known_hosts)

 The permission set on the .ssh folder, the private keys and public keys matter. To solve the problem of -

Failed to add the host to the list of known hosts (/home/username/.ssh/known_hosts)

.ssh folder - permission set to 700
public keys (id_rsa.pub or id_dsa.pub)- permission set to 644
private keys (id_rsa or id_dsa)- permission set to 600

Restore crashed Windows 7 (with no recovery image) after installing Ubuntu

Have you tried dual booting Ubuntu and Windows 7 and windows fails?

Did the Ubuntu installation complete successfully, and grub was properly installed but you still get the blue screen of death when you try booting windows?

Well, this is simple. The answer is with the file type of the windows partition.

I am assuming you have set up Ubuntu and grub is correctly installed. If not, please see https://help.ubuntu.com/community/Boot-Repair#A1st_option_:_get_a_CD_including_Boot-Repair for more information.

To correct this, boot your system to the Linux installation and run in root:

fdisk -l /dev/xxx

The Id for the windows partition (sda1 & sda2) is 42 which is the code for SFS. Change the file type Id to 7, which corresponds to HPFS/NTFS/exFAT, save and reboot.

fdisk /dev/xxx
In the prompt, type p to print the current partition table

To change the file type, type t in the prompt and enter the partition to change.

In my case, I will enter 1. 

For a list of the Hex code list of the file types, enter L in the prompt.

Enter 7 in the prompt, which corresponds to the HPFS/NTFS/exFAT file system.

Repeat the process for the second or third windows partition, and when done enter w in to save.

Reboot your system, and grub will load windows ! !  !