I am migrating a bunch of changes from our dev database, consisting of some extra tables, the data from a subset of these tables, and some new functions. Using
phpmyadmin I have exported the structure of the tables as an SQL file, and the data of the subset where I need it. However
phpmyadmin offers no way to export the functions en-masse that I can see.
Am I missing a trick, or should I just be manually creating a .sql file containing each of the function definitions?
(I appreciate that in the time it's taken to type this question and wait for answers I can probably have done the latter, but it feels inelegant given how straightforward the first 2 SQL files were to create automatically!)