Pushing stored procedure to a multisite database in WordPress
Here are the Steps: STEP 01 : Put code in a Text File Open up a text editor (vi, nano, emacs) and place your code in it. Save it as /tmp/mynewcode.sql STEP 02 : Collect All Databases Names MYSQLCONN=`-uroot -ppassword` SQLSTMT=”SELECT schema_name FROM information_schema.schemata” SQLSTMT=”${SQLSTMT} WHERE schema_name NOT IN” SQLSTMT=”${SQLSTMT} (‘information_schema’,’performance_schema’,’mysql’)” mysql ${MYSQLCONN} -ANe”${SQLSTMT}” > … Read more