I came across an issue pertaining to stored procedure in mysql database. I have two offices which both of them are running on mysql. I've created a store procedure named 'UPD_INVENTORY' on mysql server#1. Currently, I am working at an office that has mysql server#2. If I wish to use the 'UPD_INVENTORY' stored procedure on mysql server#1, is there a way that I can make a stored procedure call on mysql server#1 from mysql server#2? Does such syntax exists like this:
CALL server#1location.db_name.procedure_name ? If not what other options do I have besides using php? Will I able to use bash script in linux to accomplish such a task?