"Is it true that mojoPortal do not have any StoredProcedures?"
yes, that is true of the MySql version
one thing about MySql, on Linux table names are case sensitive, on Windows they are not and this can cause problems when moving a db from one server to another. For example on Windows to compensate for this difference, some configurations will force all lower case table names, then if you backup the db from windows and restore it on linux the lower case table names are not what mojoportal is looking for.
For a new install on linux MySql db, the tables will be camel cased like mp_Sites, mp_Pages, mp_UserProperties, but on Windows they will get often get changed to mp_sites, mp_pages, mp_userproperties. Then if you backup from windows and restore on linux mysql you need to manually rename them back to camel case or mojoPortal does not see the tables and starts trying to create them again but then errors happen.
It sounds like this is the problem in your case.