TorryCrass.com

  • About
  • Gallery

Database

Helpful Commands

MySQL Extract Single Database From Dump File

Here's a quick command line entry using sed to dump out a single MySQL database from a multi-database backup file.  This script assumes the DB file is comopressed with gzip. gunzip -c sqldumpfile.sql.gz | sed -n '/^– Current Database: `your_db_name`/,/^– Current Database: `/p' > your_db_name.sql  

By Torry Crass, 14 years13 years ago
Technical

vnStat – Database load failed even when using backup

So, you've run into a problem with vnStat.  Yeah.  Me too, after an unexpected reboot of a server the vnStat database became corrupt and was no longer usable.  It's a shame that I lost all my bandwidth history (yes, I know, you can use a cronjob to dump the stats Read more…

By Torry Crass, 14 years14 years ago
Categories
  • Business (1)
  • Helpful Commands (23)
  • Notes (2)
  • Poetry (38)
  • Quips (3)
  • Scripting (6)
  • Security (19)
  • Technical (73)
  • Updates & News (9)
Valuable Products

Affordable Linode VPS

Help Others With Kiva

0.5GB Extra Storage with OneDrive

2GB Free Storage With Dropbox

 

Copyright & Image Usage
Content and images on this site are property of Torry Crass or their respective owners where cited or referenced.
Some images used through public domain licensing and obtained via http://www.publicdomainpictures.net/

© 2010 - 2018 TorryCrass.com

  • Gallery
  • NMP License v1.0
Hestia | Developed by ThemeIsle