STORED PROCEDURE does not exist

Question

I create stored procedure from mysql client terminal and everything is OK. But when I try to call it i get this error message:

ERROR 1305 (42000): PROCEDURE XXX does not exist

After that i try to create it again without

DROP PROCEDURE IF EXISTS

statement and I get this:

ERROR 1304 (42000): PROCEDURE XXX already exists

What's wrong?

*THE PROBLEM WAS THAT MY DATABASE HAVE POINT (.) IN NAME *

*EXAMPLE: 'site.db' -> THIS IS WRONG NAME OF DATABASE AND MYSQL CAN'T FIND PROCEDURE !!!*

Answer 1

Possibly you have problems with consistency of your system databases after incorrect upgrade or something like that. What are results for

select * from information_schema.ROUTINES where routine_name = 'xxx'