Monday, December 18, 2017

Script to import table through bash script in Mysql Server




#!/bin/bash

for table in `ls /opt/databasebackup/ | grep sql`

do

    echo "Importing $table"
        /opt/lampp/bin/mysql -uroot -pPassword databasename < /opt/databasebackup/$table


done

echo "Press Any key to continue.."
read p





Thanks
nirmal Singh

Mastering Cron Jobs in Linux: A Comprehensive Guide with Examples

Introduction: Cron jobs are an indispensable tool in the world of system administration and automation. They allow users to schedule tasks t...