• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1257
  • 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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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