Step-by-Step procedure for Prepping a Legacy fore.st dataset for Migration Ingestion
- Log-in to your legacy fore.st server and dump the database
mysqldump --quick --skip-lock-tables -u forest -p forest > forest.sql
- Copy the database file locally, make a second copy called 'users.sql'
- Pop the bitch in VIM (or a lamer editor) and find the line that looks like
INSERT INTO `users` VALUES
- Delete that line and everything above it.
- Drop down to the last username entry and delete everything between it and EOF.
- You should now have a list that contains user information to be ingested by Canopies migration utilities.
ALWAYS DELETE THIS FILE AFTER IT HAS BEEN INGESTED BY CANOPY, LEAVING A PLAINTEXT FILE, ESPECIALLY ON A PRODUCTION WEB SERVER, CONTAINING OUTDATED PASSWORD HASHES, EMAILS, AND IP'S IS IRRESPONSIBLE AS SHIT!!
DATABASES HAVE SECURITY FEATURES FOR A REASON!!!