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:
    36,294
    Likes Received:
    1,207
    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:
    518
    cPanelMichael
    Dec 12, 2016
  2. fullfatdesigns

    SOLVED Find email account password

    fullfatdesigns, Jul 5, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    59
    fullfatdesigns
    Jul 5, 2017
  3. rsims

    Where do I find host name for connecting with remote client

    rsims, Jun 15, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    195
    cPanelMichael
    Jun 16, 2017
  4. Lor

    WHM did not find perl modules

    Lor, May 18, 2017, in forum: General Discussion
    Replies:
    12
    Views:
    264
    twhiting9275
    Jul 3, 2017
  5. Terrie

    Can't find where my Google map tag lives

    Terrie, May 16, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    122
    Infopro
    May 17, 2017

Share This Page