MySQL backup recovery

[d_saint_PT]

Hi,
I'm facing a couple of issues after recovering a database from the backup (manual recover from the scripts)

The DB was deleted by the user probably via phpmyadmin, not sure, so, deleted grants, etc.

The issue is that, now , I can't login to phpmyadmin via the cwppro.user panel for clients . With the pro.admin yes, but seems that the user can't login.

The grant has the main user there so, that might have messed it up. Already tried to reset the user's account password to see if the mysql user would get updated but no luck.


The other issue is that the client is complaining about a missing stored procedure but I can't see that on the backup script. Are stored procedures backed up?


Thanks in advance for any help provided.

Best regards
Daniel

[overseer]

Do you have backups enabled? You should be backing up daily, weekly, monthly. I also make a practice of regularly doing a mysqldump of all DB, so I can do disaster recovery for clients if needed.