MySQL backup script

This script is made using dialogues
So without dialogue package it will not work

You can start a mysql instance in full customized way

The script is mainly focused on MySQL compiled from source code

The script is using a config file to get necessary information to store values like

path to mysql daemon ,myql dump,mysql safe ,user name and password to start mysql instance

You can download the script from the following link

The advantage is ,You can take the entire database as well as a particular table of a schema using this script.


https://sites.google.com/site/ansilh/mysql-backup-script/mybackup.sh

Comments

  1. MySQL Backup ScriptJune 12, 2018 at 6:32 AM

    I found best MySQL backup script and it works well. Thanks for sharing valuable information.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Configure YUM in RHEL6

Easy way to create your own repo 1. Put your RHEL6 media on DVD drive 2. Create a partition with size 6GB and mount it as /yum 3. Download the below script to /yum https://sites.google.com/site/ansilh/rhel6_repo.sh 4. Give execute permission to the downloaded script 5. Please open the file and try to understand it. If you found all safe ,then go to next step 6. Execute it...You will get an RHEL repo accessible through ftp ***Please feel free to comment your experience *** ======================================= Manual Steps (*Different approach from above script .The repo file not look like usual one) YouTube Link : http://www.youtube.com/watch?v=scBtTTwLze0   1.create a directory to store packages .(Better you create a partition with 5GB size and mount it as /YUM) mkdir /YUM 2.mount RHEL6 DVD mount /dev/dvd /mnt 3.go to the mounted directory cd /mnt/Packages/ 4.copy all contents of DVD to /YUM (Note the "." in command ) cp . /YUM/ 5.Install create
Read more

How to Configure Squid with Mysql DB authentication

Download squid source from http://www.squid-cache.org/Versions/v3/3.0/squid-3.0.STABLE24.tar.gz Copy the downloaded file to /tmp Tar –zxvf squid-3.0.STABLE24.tar.gz Cd squid-3.0.STABLE24 ./configure --enable-basic-auth-helpers=DB make make install Download Current Mysql5.1 Source RPM from http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-5.1.44-1.glibc23.src.rpm/from/ftp://mirror.anl.gov/pub/mysql/ Copy MySQL-5.1.44-1.glibc23.src.rpm /tmp Rpm –ivh MySQL-5.1.44-1.glibc23.src.rpm Cd /usr/src/redhat/SPEC Rpmbuid –bb mysql-5.1.44.spec After compilation the RPM files will be in /usr/src/redhat/`uname –m`/RPMS Cd /usr/src/redhat/`uname –m`/RPMS Rpm –ivh MySQL-server-5.1.44-1.glibc23.ia64.rpm The service will start automatically after installation Here we are using Default Mysql database engine MyISAM (Non transactional Engine) In a large application Database we will use Engine INNODB (Transactional engine).It has many configurable options to get mysql to work efficiently with maximum perf
Read more

HMC vtmenu exit

You can exit the cosole of an LPAR ,that has been taken using HMC vtmenu ,by typing "~." (press dot key after tild without qoutes ) If you had taken HMC vtmenu using SSH ,your ssh connection to HMC will alse loses.
Read more