Monitering load database in mysql

Hi Srihari,

What exactly you want to monitor in MySQL ?

HI,

I want to monitor database refresh,when loading database into mysql I want see the below output,so that I can see if any error occurs.

table1 completed.. table2 completed.. table3 completed.. table4 completed.. . . . . tablen completed.. database loaded successfully completed..

Thanks Srihari

Hi,

The output you just provided could be gotten by having your database’s tables backed up individually and then restore them the same way.
For this purpose, the backup script should be something like:

#!/bin/bash
cd /backup/script/
for x in `cat tables.txt`
do 
echo $x
mysqldump --user=user_name --password='password' database_name $x  > /backup/$x.sql

echo 'Table '.$x.' completed ...'
done
echo 'Database backed up successfully ...'

Where the tables.txt file contains all tables names separated by new lines.

And the restore script should be something like:

#!/bin/bash
cd /backup/script/
for x in `cat tables.txt`
do 
echo $x
mysql --user=user_name --password='password' database_name < /backup/$x.sql

echo 'Table '.$x.' completed ...'
done
echo 'Database loaded successfully ...'

# pv /backup/database_backup_file.sql | mysql --user=user_name --password='password' database_name
96.8MB 0:00:17 [5.51MB/s] [==>                                ] 11% ETA 0:02:10

BTW, at the end of each method, you might need to run the mysqlcheck command against the restored database to double check that everything is going fine after the restore.

I hope that helped.

Abdel-Mawla

Thank you very much.