Today I wanted to copy all the data from the live to the dev db, to do some testing with the new codebase. I found that one of the procedures implemented on dev was broken (presumably it wasn't updated when the live db was fixed by JN recently). I tried deleting the broken procedure, which took several minutes and locked up my session on phpMyAdmin, but eventually worked. Then I tried recreating it using the code from the live db, but this would not work at all. I concluded that for some reason, procedures and functions can only be created from a CLI session on the server. I have a vague memory that we've discovered this before; JN had to connect to the server to make his updates to the procedures.

In the end, I concluded that since the triggers and procedures only exist in order to keep the poem_search table updated for the WordPress site search, I don't really need them on the dev db to test the data-entry GUI, so I've stripped all the triggers from the dev db. That means we can't actually test the triggers and procedures if we have to work on them, so at some point I'll have to log into mysql and reconstruct them, but I'll do that when we need it.