Hacker News new | ask | show | jobs
by cyphax 896 days ago
I've done something similar before, though it was a client's database. They needed an empty copy of their database for a second instance of the software they were running, so I had the tool I was using create a massive DDL-script, then created the new database, selected it and ran the DDL-script in there. The script ran without errors, but all the tables in the original database were now empty. The script that was created by the tool started off with more than a screen full of comments, so I overlooked the "USING [original database]" statement that was the actual start of the script. Because their backup strategy didn't work well, it took until late that night before the person responsible for backups managed to pull the most recent backup (from end of the day before) from tape which I could then restore.