Hacker News new | ask | show | jobs
by james_s_tayler 1651 days ago
I like how the arguments used to import the database need to match the arguments used to export the database. I can recall on two separate occasions receiving a database dump from a client site that took us two weeks to figure out how to successfully import. The second time we wound up writing a series of bash scripts that used the strings command on the database dump file in order to grep/sed/awk enough information to reconstruct the arguments needed to successfully import the database. We wound up taking it that far because the other two offices that worked on the product we did had DBAs and ours didn't, so their process when they needed to replicate bugs customers were reporting was to pester the DBA to import a DB for them which would take several days, and our process was to import it instantly via our magic script. Fun times.