mysqlsqlphpmyadminxampproutines

phpMyAdmin routines not showing


I have created a database and routines with MySQL Workbench. After I exported the SQL create script, I imported it into the phpMyAdmin, successfully executing 1065 queries, on my localhost XAMPP installation and it works perfectly, routines and all.

The problem is that when I try to do the same on a server at my workplace, the routines never show. There are no errors in importing the script, it executes the same 1065 queries with no errors, but when I go to the routines tab it doesn't show anything, just a blank screen, and doesn't even let me add new routines. I can't seem to figure out what the problem is.


Solution

  • Probably the version of phpMyAdmin is different in both servers, so maybe you are trying to see the routines in a version that do not support them correctly.

    For ensure that you correctly import your routines try selecting them:

    SELECT routine_definition
    FROM information_schema.routines
    WHERE 
    routine_name = 'routine_name' AND routine_schema = 'database_name';