How can I find out who deleted a MySQL Databse?

em.ci

• June 15, 2015 02:24

Hi Which Log-File can I analyze to find out who or what has happened to a database. Thanks in advance!

• 

  LostNerd

  • June 15, 2015 09:31

  I don't believe there is a way to find this out however, if that database was still required, you should be able to retrieve it from a cpbackup file.

  0
• 

  em.ci

  • June 15, 2015 09:58

  Many thanks for your response. Then I'll try to restore. I thought it would be a way to check this. Regards, em.ci

  0
• 

  LostNerd

  • June 15, 2015 13:53

  If you open the backup file, you should find a file in there containing MySQL dumps for each database. If you re-create the database manually in cPanel, you can import that .sql file respectively. That way you do not have to restore a full backup and risk losing any changes made since that backup. Hope this helps!

  0
• 

  cPanelMichael

  • June 15, 2015 15:10

  Hello, You could review /usr/local/cpanel/logs/access_log to see if any unfamiliar IP addresses accessed cPanel under a certain username and viewed the "MySQL Databases" page. Thank you.

  0
• 

  em.ci

  • June 19, 2015 09:17

  Many thanks for your help guys! I restored the Database as you told me to do. Regards, em.ci

  0
• 

  LostNerd

  • June 19, 2015 09:58

  Thanks for updating us. Glad you've got it sorted.

  0

Please sign in to leave a comment.