TorryCrass.com

  • About
  • Gallery

MySQL

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

Remove Orphaned Topics and Private Messages in phpBB

I recently had to clear out a slew of accounts from a phpBB installation.  In the process some private messages were not removed since I handled a lot of the removal process manually rather than through the phpBB interface.  As such, I needed a way to remove the orphaned private 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