Display the Progress of a MySQL Restore
At work every week or so I need to restore a 5+ GB mysql database because someone deleted or overwrote something accidentally (this has gotten better now that we don't delete anything). But it still happens and during the restore we're presented with a nice blank screen as it's doing it's work.
You can use the pv
command to monitor the progress of the data going through a pipe. In our case we backup the data using mysqldump and then pipe it through gzip to take it down to a more reasonable file size. In the restore process we have to unzip it but we can restore it using a one liner:
pv mysqldump.sql.gz | gunzip | mysql -uusername -p databasename
Scott Keck-Warren
Scott is the Director of Technology at WeCare Connect where he strives to provide solutions for his customers needs. He's the father of two and can be found most weekends working on projects around the house with his loving partner.
Top Posts
- Working With Soft Deletes in Laravel (By Example)
- Fixing CMake was unable to find a build program corresponding to "Unix Makefiles"
- Upgrading to Laravel 8.x
- Get The Count of the Number of Users in an AD Group
- Multiple Vagrant VMs in One Vagrantfile
- Fixing the "this is larger than GitHub's recommended maximum file size of 50.00 MB" error
- Changing the Directory Vagrant Stores the VMs In
- Accepting Android SDK Licenses From The OSX Command Line
- Fixing the 'Target class [config] does not exist' Error
- Using Rectangle to Manage MacOS Windows