• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1269
  • Last Modified:

using phpMyAdmin with MySQL

is it possible to export tables of stored procedures from a MySQL DB using phpMyAdmin? I know it can export data tables but i need to export stored procs. http://www.phpmyadmin.net/documentation/
if yes, how?
0
jhshukla
Asked:
jhshukla
  • 3
  • 2
1 Solution
 
snoyes_jwCommented:
The stored procedures are held in the information_schema database, in the `routines` table.  You can export that just like any other table.
0
 
jhshuklaAuthor Commented:
when you say "stored procedures are held in the information_schema database", it raises the question - are procedures shared between multiple databases?
0
 
snoyes_jwCommented:
No.  You'll see a field in the routines table called `routine_schema`, which names the database to which the procedure belongs.
0
 
jhshuklaAuthor Commented:
in that case, can the procedure be shared? i am not asking whether it is shared or not, but is it possible to name multiple databases in routine_shema?
0
 
snoyes_jwCommented:
No.  You can run a procedure from one database while using another using schema_name.procedure_name syntax, just like you can select from tables in different databases in a single query.  But a procedure belongs to just one database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now