Calling procedures from different Shemas MySQL -

Calling procedures from different Shemas MySQL -

i have used mysql few months , have liked it. have question using procedures between different schemas.

to give context, working local re-create of database job. when create procedures database, of them want upload server, others rather want maintain on local computer. however, ones maintain in computer deleted when load new backup re-create of production database.

where safe place or way save these procedures in computer. should maintain separate schema local procedure, , able phone call them backed schema? there way this?

thanks,

yes, can set procedures in separate schema. query references table within procedure should qualified schema name.

begin select ... dbname.tablename; end

mysql stored-procedures schema