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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,961
    Likes Received:
    1,821
    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,369
    cPanelMichael
    Dec 12, 2016
  2. webstuff

    Trying to find the cause of a php script exe:/usr/bin/php cmd:/usr/bin/php

    webstuff, Jul 10, 2018, in forum: Security
    Replies:
    3
    Views:
    60
    cPanelLauren
    Jul 10, 2018
  3. lilidia

    The server can not find the requested page error

    lilidia, Jun 23, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    3
    Views:
    126
    cPanelLauren
    Jun 25, 2018
  4. Jonathon.M

    Use API to find the package name a user is on?

    Jonathon.M, May 31, 2018, in forum: cPanel Developers
    Replies:
    2
    Views:
    60
    cPanelLauren
    May 31, 2018
  5. Neutrall

    SOLVED finding the current install SSL from SSH

    Neutrall, May 3, 2018, in forum: cPanel Developers
    Replies:
    4
    Views:
    133
    Neutrall
    May 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