<div>
when you say &quot;stored procedures are held in the information_schema database&quot;, it raises the question - are procedures shared between multiple databases?
</div>


when you say "stored procedures are held in the information_schema database", it raises the question - are procedures shared between multiple databases?

<div>
No. &nbsp;You'll see a field in the routines table called `routine_schema`, which names the database to which the procedure belongs.
</div>


No.  You'll see a field in the routines table called `routine_schema`, which names the database to which the procedure belongs.

<div>
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?
</div>


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?

<div>
No. &nbsp;You can run a procedure from one database while using another using schema_name.procedure_name<wbr /> syntax, just like you can select from tables in different databases in a single query. &nbsp;But a procedure belongs to just one database.
</div>


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.

<div>
<div class="content wysiwyg-content">
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. <a href="http://www.phpmyadmin.net/documentation/" rel="ugc">http://www.phpmyadmin.net/documentation/</a><br />
if yes, how?
</div>
</div>


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?

using phpMyAdmin with MySQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.