CiviCRM Community Forums (archive)

I noticed that CiviCRM uses a MySQL stored function. With a default mysqldump or phpadmin export this function was not included. I googled and I did not see any explicit mention of this in the CiviCRM context. May be because this stored function was only recently introduced?

When you do a mysqldump apparently you have to add the --routines or -R switch to include also these in your dump. I went through a complete reinstall before I found out it had to do with the missing function in the dump file that CiviCRM did not restore correctly. Since you only notice this problem when you restore to a complete blank database, it might be that this has drawn little attention. Still the same I think it is important to highlight it somewhere in documentation. 

Are you talking about the "STRIP NON NUMERIC" function?
CiviCRM will automatically rebuild that at runtime if it detects it is missing (which is probably why you don't hear complaints).