Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 down vote accepted

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

share|improve this answer
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 1 '11 at 11:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.