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!
  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 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.
     
    #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!
     
    #4 LostNerd, Jun 15, 2015
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,031
    Likes Received:
    1,360
    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.
     
    #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.
     
    #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:
    637
    cPanelMichael
    Dec 12, 2016
  2. tecwithquestion

    find user's addon domain and subdomain folder path

    tecwithquestion, Sep 11, 2017, in forum: cPanel Developers
    Replies:
    3
    Views:
    87
    cPanelMichael
    Sep 12, 2017
  3. hinhthoi

    SOLVED How to find which domains using a specific PHP version?

    hinhthoi, Sep 9, 2017, in forum: General Discussion
    Replies:
    4
    Views:
    74
    cPanelMichael
    Sep 12, 2017
  4. tecwithquestion

    Find user homedir

    tecwithquestion, Sep 6, 2017, in forum: cPanel Developers
    Replies:
    1
    Views:
    57
    cPanelMichael
    Sep 6, 2017
  5. Kikloo

    How to find out domains which are parked on accounts ?

    Kikloo, Sep 5, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    1
    Views:
    50
    Infopro
    Sep 5, 2017

Share This Page