0

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!)

James Green
  • 895
  • 1
  • 9
  • 23

1 Answers1

5

Check 'Add CREATE PROCEDURE / FUNCTION' in export page.

alvosu
  • 8,437
  • 25
  • 22
  • ARGH! How did I miss that? But, how do I select which functions I want to export? Is it clever enough to only do those that can relate to the tables being exported? – James Green Feb 01 '11 at 11:51