Home / server / Questions / 229594
Accepted
James Green
Asked: 2011-02-02 03:38:06 +0800 CST

Easiest way to export functions from a MySQL DB

  • 772

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

mysql database-administration

1 Answers

  1. Best Answer

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

    • 5