Control Web Panel

WebPanel => MySQL => Topic started by: maquinadigital on September 12, 2024, 05:58:58 PM

Title: MySQL backup recovery
Post by: maquinadigital on September 12, 2024, 05:58:58 PM

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

Title: Re: MySQL backup recovery
Post by: overseer on September 13, 2024, 01:46:09 AM

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.