Recreate MySQL stored functions and procedures

When you create a database using CreateDB.sh, you also add a number of stored functions and procedures, which are system-wide, as opposed to just belonging to the wikidb database.

If you restore a database from another Deki, you do not get these added.  You should always create a database with the correct version of CreateDB.sh before restoring a database.

If you did not, there is a workaround.  Change to /var/www/dekiwiki/maintenance and run the following commands.  The first five lines set up variables (much as CreateDB.sh does with its command-line parameters) and you should set them to match your MySQL user, server, database, admin user and admin password, respectively.

# edit the db_ variable assignments before executing them
db_wiki_user=wikiuser
db_server=localhost
db_name=wikidb
db_admin_user=root
db_admin_password=password
MYSQL=`which mysql`
# create stored procs
cat archives/sprocs-*.sql | sed -e "s/{\$wgDBuser}/${db_wiki_user}/" -e "s/{\$wgDBserver}/${db_server}/" -e "s/{\$wgDBname}/${db_name}/" -e "s/{\$wgDBadminuser}/${db_admin_user}/" -e "s/{\$wgDBadminpassword}/${db_admin_password}/" | ${MYSQL} -u ${db_admin_user} -p${db_admin_password} -h ${db_server} ${db_name}

# create mysql FUNCTIONS
cat archives/funcs-*.sql | sed -e "s/{\$wgDBuser}/${db_wiki_user}/" -e "s/{\$wgDBserver}/${db_server}/" -e "s/{\$wgDBname}/${db_name}/" -e "s/{\$wgDBadminuser}/${db_admin_user}/" -e "s/{\$wgDBadminpassword}/${db_admin_password}/" | ${MYSQL} -u ${db_admin_user} -p${db_admin_password} -h ${db_server} ${db_name}

 On Windows, you will need GNU cat and GNU sed, both of which are attached to this page. Do the variable substitutions in the command line yourself, like so:

REM create stored procs
cat archives/sprocs-*.sql | sed -e "s/{\$wgDBuser}/wikiuser/" -e "s/{\$wgDBserver}/localhost/" -e "s/{\$wgDBname}/wikidb/" -e "s/{\$wgDBadminuser}/root/" -e "s/{\$wgDBadminpassword}/(passwordhere)/" | mysql -u root -p(passwordhere) -h localhost wikidb

REM create mysql FUNCTIONS
cat archives/funcs-*.sql | sed -e "s/{\$wgDBuser}/wikiuser/" -e "s/{\$wgDBserver}/localhost/" -e "s/{\$wgDBname}/wikidb/" -e "s/{\$wgDBadminuser}/root/" -e "s/{\$wgDBadminpassword}/(passwordhere)/" | mysql -u root -p(passwordhere) -h localhost wikidb

Replace values for wikiuser, localhost, wikidb, root and password as appropriate.  You will need to put cat and sed somewhere in your path, or the maintenance directory itself.