Shell script for Mysql Database Backup

#  mkdir /backups/db_backup/

# vi /backups/mysqlbackup.sh 

#!/bin/bash
export path1=/backups/db_backup
date1=`date +%y%m%d_%H%M%S`
/usr/bin/find /backups/db_backup/* -type d -mtime +30 -exec rm -r {} \; 2> /dev/null
cd $path1/
mkdir $date1
USER="root"
PASSWORD="redhat123"
OUTPUTDIR="$path1/$date1"
MYSQLDUMP="/usr/bin/mysqldump"
MYSQL="/usr/bin/mysql"
HOST="localhost"
databases=`$MYSQL --user=$USER --password=$PASSWORD --host=$HOST \
-e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
echo "` for db in $databases; do
   echo $db

       if [ "$db" = "performance_schema" ] ; then
       $MYSQLDUMP --force --opt --single-transaction --lock-tables=false --skip-events --user=$USER --password=$PASSWORD --host=$HOST --routines \
        --databases $db | gzip > "$OUTPUTDIR/$db.gz"
        else

$MYSQLDUMP --force --opt --single-transaction --lock-tables=false --events --user=$USER --password=$PASSWORD --host=$HOST --routines \
   --databases $db | gzip > "$OUTPUTDIR/$db.gz"
fi
done `"

:wq



Now schedule the script inside crontab:-
#The  script will run every night at 12 A.M
#crontab -e
0 0 * * * /backups/mysqlbackup.sh > /dev/null


Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.

Windows Server 2012 R2 with Update 64bit download link

Microsoft Windows Server R2 with Update 64bit  download link with  cd key:-


https://onedrive.live.com/redir?resid=B9CA6221A841D988!191&authkey=!AMl9VeD2J5RUQOw&ithint=folder%2crar


Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.

How to take Full, Differential & Transaction log backup & restore it using T-SQL

Full backup:-

USE "TESTDB"
GO
BACKUP DATABASE "testdb"
TO DISK = 'E:\TESTDB02101.BAK'
GO


Differential backup or incremental backup:-


Prerequisites:-
Creating a differential database backup requires that a previous full database backup exist. If the selected database has never been backed up,
run a full database backup before creating any differential backups. For more information, see Create a Full Database Backup (SQL Server).

USE "TESTDB"
BACKUP DATABASE "TESTDB"
TO DISK = 'E:\TESTDB02101_DIFF.BAK'
WITH DIFFERENTIAL
GO



Transaction Log backup:-


Recommendations:-
If a database uses either the full or bulk-logged recovery model, you must back up the transaction log regularly enough to protect your data and to keep the transaction
log from filling. This truncates the log and supports restoring the database to a specific point in time.


USE "TESTDB"
BACKUP LOG "TESTDB"
TO DISK = 'E:\TESTDB02101_TRANS.TRN'
GO




First drop the database and then start the restoration process.
drop database "TESTDB"
GO



Now to restore the database using transaction log use the following T-SQL scripts.


RESTORE DATABASE "TESTDB"

FROM DISK = 'E:\TESTDB02101.BAK'

WITH

NORECOVERY;
GO
-----
RESTORE DATABASE "TESTDB"
FROM DISK = 'E:\TESTDB02101_DIFF.BAK'
WITH NORECOVERY;
GO
-----
RESTORE LOG "TESTDB"
FROM DISK = 'E:\TESTDB02101_TRANS.TRN'
WITH RECOVERY;
GO





Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.

User creation in Mysql where dbname consist hyphen

We can create a user that consists of no special character at ease.

mysql>  create user 'abc'@'localhost' identified by 'redhat';

But to create a user for a database which consists of special character we follow this:-

mysql> grant all privileges on `Emp-Kolkata`.* to soumya@'localhost' identified by 'redhat';

mysql> grant all privileges on `Emp-Kolkata`.* to soumya@'%' identified by 'redhat';

mysql> flush privileges;

So the above command shows how to create a user for a dbname that consists hyphen in it and we granted all privileges to that user for both localhost and remote location.




Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.

Mysql Database backup & restore command

Mysql single database backup:-

mysqldump --force --opt --single-transaction --lock-tables=false --skip-events --user=root --password=xxxx --routines --databases testdb > singledb.sql

Mysql all database backup:-

mysqldump --force --opt --single-transaction --lock-tables=false --skip-events --user=root --password=xxxx --routines --all-databases > all_databases.sql

Mysql Restore database:

mysql -u root -predhat dbname < /mnt/dbname.sql



Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.

RPM Packages for MYSQL 5.6 for RHEL 6

RPM Packages of MYSQL 5.6 for RHEL 6

Download link:-

MySQL-shared-compat-5.6.16-1.el6.x86_64.rpm :- https://onedrive.live.com/redir?resid=B9CA6221A841D988!223&authkey=!AMa8AftKb_lqNpw&ithint=file%2crpm

MySQL-embedded-5.6.16-1.el6.x86_64.rpm :- https://onedrive.live.com/redir?resid=B9CA6221A841D988!224&authkey=!ADwJirI81CEkNII&ithint=file%2crpm


MySQL-client-5.6.16-1.el6.x86_64.rpm :- https://onedrive.live.com/redir?resid=B9CA6221A841D988!229&authkey=!AH5t4UWp6D1NPMk&ithint=file%2crpm

MySQL-devel-5.6.16-1.el6.x86_64.rpm:- https://onedrive.live.com/redir?resid=B9CA6221A841D988!227&authkey=!AI8_nSebOGg-s8I&ithint=file%2crpm

MySQL-server-5.6.16-1.el6.x86_64.rpm:- https://onedrive.live.com/redir?resid=B9CA6221A841D988!228&authkey=!AMFWXuGrmYtBh_4&ithint=file%2crpm

MySQL-shared-5.6.16-1.el6.x86_64.rpm:- https://onedrive.live.com/redir?resid=B9CA6221A841D988!225&authkey=!AJT7lgzWWH_Zl-I&ithint=file%2crpm

MySQL-test-5.6.16-1.el6.x86_64.rpm:- https://onedrive.live.com/redir?resid=B9CA6221A841D988!226&authkey=!AHtBP6ksXCtblUQ&ithint=file%2crpm



Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.

Microsoft SQL Server 2012 Enterprise Edition Service pack 1 64bit download link

Microsoft SQL Server 2012 Enterprise Edition Service pack 1 64 bit download link with no cd key required:-


https://mega.nz/#F!HcYQ2bJI!4PmsBXpEm0SpHhJeRKK5jg


Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.