Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.