Before I begin today’s article, I would just like to preface this and say that i am working on a series about how I set up my development environment. It is slightly complicated, but I am proud of it, and will post that series soon.
For today, I recently had to rebuild my development web server and did a mysql dump to backup all of my application databases. I did not know that doing a backup this way does not back up user defined functions (UDFs) and had to rebuild them from scratch. For my own sake, as well as to hopefully help others, I would like to go over the two UDFs I am using.