Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

How can I find out who deleted a MySQL Databse?

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

  1. em.ci

    em.ci Well-Known Member

    Joined:
    Jun 15, 2015
    Messages:
    47
    Likes Received:
    2
    Trophy Points:
    8
    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!
     
    #1 em.ci, Jun 15, 2015
  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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 LostNerd, Jun 15, 2015
  3. em.ci

    em.ci Well-Known Member

    Joined:
    Jun 15, 2015
    Messages:
    47
    Likes Received:
    2
    Trophy Points:
    8
    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
     
    #3 em.ci, Jun 15, 2015
  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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 LostNerd, Jun 15, 2015
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,704
    Likes Received:
    1,883
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelMichael, Jun 15, 2015
  6. em.ci

    em.ci Well-Known Member

    Joined:
    Jun 15, 2015
    Messages:
    47
    Likes Received:
    2
    Trophy Points:
    8
    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
     
    #6 em.ci, Jun 19, 2015
  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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 LostNerd, Jun 19, 2015
(You must log in or sign up to post here.)
Loading...
Similar Threads - find deleted MySQL
  1. Sarath Kumar R

    SOLVED How to find which IP deleted files from cPanel file manager

    Sarath Kumar R, Dec 6, 2016, in forum: General Discussion
    Replies:
    6
    Views:
    1,550
    cPanelMichael
    Dec 12, 2016
  2. denverdataman

    Cannot Find Log of 500 Error

    denverdataman, Sep 12, 2018 at 10:10 AM, in forum: General Discussion
    Replies:
    2
    Views:
    39
    cPanelMichael
    Sep 12, 2018 at 1:26 PM
  3. cPanelResources

    Tutorial How to find email headers

    cPanelResources, Aug 6, 2018, in forum: E-mail Discussion
    Replies:
    0
    Views:
    87
    cPanelResources
    Aug 6, 2018
  4. Usif Nasirov

    SOLVED Can't find cause of CBL blocking

    Usif Nasirov, Aug 2, 2018, in forum: E-mail Discussion
    Replies:
    2
    Views:
    107
    cPanelMichael
    Aug 2, 2018
  5. Luana Premoli

    Failed to find user for the virtual_aliases_nostar router

    Luana Premoli, Jul 30, 2018, in forum: E-mail Discussion
    Replies:
    9
    Views:
    122
    cPanelLauren
    Aug 3, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice