The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How can I find out who deleted a MySQL Databse?

Discussion in 'Database Discussions' started by em.ci, Jun 15, 2015.

  1. em.ci

    em.ci Active Member

    Joined:
    Jun 15, 2015
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Switzerland
    cPanel Access Level:
    Root Administrator
    Hi

    Which Log-File can I analyze to find out who or what has happened to a database.


    Thanks in advance!
     
  2. LostNerd

    LostNerd Well-Known Member

    Joined:
    Mar 12, 2014
    Messages:
    258
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Hastings, East Sussex, UK
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
  3. em.ci

    em.ci Active Member

    Joined:
    Jun 15, 2015
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Switzerland
    cPanel Access Level:
    Root Administrator
    Many thanks for your response.

    Then I'll try to restore. I thought it would be a way to check this.

    Regards,
    em.ci
     
  4. LostNerd

    LostNerd Well-Known Member

    Joined:
    Mar 12, 2014
    Messages:
    258
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Hastings, East Sussex, UK
    cPanel Access Level:
    Root Administrator
    Twitter:
    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!
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  6. em.ci

    em.ci Active Member

    Joined:
    Jun 15, 2015
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Switzerland
    cPanel Access Level:
    Root Administrator
    Many thanks for your help guys!

    I restored the Database as you told me to do.

    Regards,
    em.ci
     
  7. LostNerd

    LostNerd Well-Known Member

    Joined:
    Mar 12, 2014
    Messages:
    258
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Hastings, East Sussex, UK
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thanks for updating us. Glad you've got it sorted.
     
Loading...

Share This Page