Andrew Hutchings: Viewing the MySQL dump import progress
A couple of years ago I wrote a patch for the MySQL command line client which shows the progress of a import as it happens (I also created a similar patch for mysqldump which later made it into Drizzle). I don’t have the blog archives from back then but Harrison Fisk commented suggesting I use a utility called ‘bar‘ instead.
The ‘bar’ utility actually is a lot better than the patch I wrote and I highly recommend it when you are importing a large dump file. To use it simply run:
shell> bar -if=data.sql | mysql
This will generate an output such as:
If you are using Ubuntu then it is a simple case of ‘sudo apt-get install bar’ to install it. Enjoy!
URL: http://www.linuxjedi.co.uk/?p=213
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
