Restore database improve code Post: 303046011

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Restore database improve code Post 303046011 by mustfirst on Tuesday 21st of April 2020 03:03:56 PM

04-21-2020

Registered User

Restore database improve code

let me know if you can suggest any improvement in my code. I think i have too many ECHO.

Code:

#! /bin/bash

DATABASE=$1
DATE=$2
MYLOGIN=/home/dbadmin/login_dev.ini
BKUP_FILE=/home/dbadmin/delete
DB_NAME=$DATABASE.sql.gz


DBEXISTS=$(mysql --defaults-extra-file=$MYLOGIN --batch --skip-column-names -e "SHOW DATABASES LIKE '"$DATABASE"';" | grep "$DATABASE" > /dev/null; echo "$?")


if [ $DBEXISTS -eq 0 ];then
    clear
	
	echo ".........................................................................."
	echo "$DATABASE already exists. Back up and drop $DATABASE before running restore_full_db.sh. Exiting..."
	echo ".........................................................................."
	echo ""
	echo ""
	
	exit
else 	

	if [ -f $BKUP_FILE/$DATE/$DB_NAME ] 
		then
		
			clear
		
			echo "$DB_NAME decompressed"
			echo ".........................................................................."
			gzip -d $BKUP_FILE/$DATE/$DB_NAME
			echo ""
			echo ""
			echo ""

			echo "$DATABASE created"
			echo ".........................................................................."
			mysql --defaults-extra-file=$MYLOGIN <<< "create database $DATABASE"
			echo ""
			echo ""
			echo ""

			echo "Data restoring in $DATABASE"
			echo ".........................................................................."
			mysql --defaults-extra-file=$MYLOGIN "$DATABASE" < "$BKUP_FILE/$DATE/$DATABASE.sql"
			echo ""
			echo ""
			echo ""
			echo "Data restored. Exit..."
			echo ""
			echo ""
			echo ""

		else
			
			echo ".........................................................................."
			echo "$DB_NAME file not found. Exiting..."
			echo ".........................................................................."
			echo ""
			echo ""
			
			exit
	fi

fi

Moderator's Comments:

Code tags please.

Last edited by Peasant; 04-22-2020 at 01:17 AM..

mustfirst

View Public Profile for mustfirst

Find all posts by mustfirst

4 More Discussions You Might Find Interesting

1. AIX

mksysb restore - Wrong OS level for restore

Hi all, I am still working on my mksysb restore. My latest issue is during an alt_disk_install from tape I got the following error after all the data had been restored. 0505-143 alt_disk_install: Unable to match mksysb level 5.2.0 with any available boot images. Please correct this...

2. Solaris

Restore a database on solaris..

hi All, Can anyone help me with the set of commands which are used to restore maybe a sybase database on solaris..

3. Programming

Improve the performance of my C++ code

Hello, Attached is my very simple C++ code to remove any substrings (DNA sequence) of each other, i.e. any redundant sequence is removed to get unique sequences. Similar to sort | uniq command except there is reverse-complementary for DNA sequence. The program runs well with small dataset, but...

4. Shell Programming and Scripting

Improve awk code that has three separate parts

I have a very inefficient awk below that I need some help improving. Basically, there are three parts, that ideally, could be combined into one search and one output file. Thank you :). Part 1: Check if the user inputted string contains + or - in it and if it does the input is writting to a...

LEARN ABOUT PHP

boolval

BOOLVAL(3)								 1								BOOLVAL(3)

boolval - Get the boolean value of a variable

SYNOPSIS

       boolean boolval (mixed  $var)

DESCRIPTION

	Returns the boolean value of $var.

PARAMETERS

	      o $var
		- The scalar value being converted to a boolean.

RETURN VALUES

	The boolean value of $var.

EXAMPLES

       Example #1

	      boolval(3) examples

	      <?php
	      echo '0:	      '.(boolval(0) ? 'true' : 'false')."
";
	      echo '42:       '.(boolval(42) ? 'true' : 'false')."
";
	      echo '0.0:      '.(boolval(0.0) ? 'true' : 'false')."
";
	      echo '4.2:      '.(boolval(4.2) ? 'true' : 'false')."
";
	      echo '"":       '.(boolval("") ? 'true' : 'false')."
";
	      echo '"string": '.(boolval("string") ? 'true' : 'false')."
";
	      echo '"0":      '.(boolval("0") ? 'true' : 'false')."
";
	      echo '"1":      '.(boolval("1") ? 'true' : 'false')."
";
	      echo '[1, 2]:   '.(boolval([1, 2]) ? 'true' : 'false')."
";
	      echo '[]:       '.(boolval([]) ? 'true' : 'false')."
";
	      echo 'stdClass: '.(boolval(new stdClass) ? 'true' : 'false')."
";
	      ?>

	      The above example will output:

	      0:	false
	      42:	true
	      0.0:	false
	      4.2:	true
	      "":	false
	      "string": true
	      "0":	false
	      "1":	true
	      [1, 2]:	true
	      []:	false
	      stdClass: true

SEE ALSO

       floatval(3), intval(3), strval(3), settype(3), is_bool(3), Type juggling.

PHP Documentation Group 														BOOLVAL(3)