Performing a Selective mysqldump
At work today somebody accidentally deleted a couple rows from our production database. Normally, this wouldn't be so bad but when the website deleted those row it also deleted a little over a 150 other rows that were dependent on it. I would just copy these rows over using an insert ... select but those can be error prone when dealing with the 25 columns that this table had so I had to find another way to restore the data.
mysqldump has a parameter that allows you create a dump file that allows you to specify what rows to dump:
mysqldump -uroot -ppassword databaseName tableName --where='foreignId in (802, 803, 804)'
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