Monitering load database in mysql

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 ...'

OR if you have all tables backed up in only one file, you can monitor the whole process progress by using the "pv" command in the restore as follows:

# 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