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.

Entire MYSQL Directory is backing up per account?

Discussion in 'Data Protection' started by Jimbo222, Jun 13, 2016.

  1. Jimbo222

    Jimbo222 Registered

    Joined:
    Jun 13, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United States
    cPanel Access Level:
    Website Owner
    In backup config I have "Entire MySQL Directory" selected as I have some db's not associated with any account. What I understand is that this option will backup all db's on the server. When I look through the backup archive for any one specific account, I see a mysql folder containing all of the db backups for that account.

    So my question is, if I am selecting "Entire MySQL Directory" and it's also backing them up per account, then how is the option "Per Account and Entire MySQL Directory" any different?

    Also, I can't see to find where the "Entire MySQL Directory" backup is located. Where would I find the backups of the db's not attached to any cpanel account?
     
    #1 Jimbo222, Jun 13, 2016
  2. twhiting9275

    twhiting9275 Well-Known Member

    Joined:
    Sep 26, 2002
    Messages:
    545
    Likes Received:
    15
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Twitter:
    From the documentation:
    I'm guessing that this is just an rsync as opposed to mysqldump (which the actual db dump is), so probably not what you want to use here.

    What I would personally suggest is running a mysqldump every few hours , on the databases that aren't owned by your users. Store it on a remote server.
     
    #2 twhiting9275, Jun 13, 2016
  3. Jimbo222

    Jimbo222 Registered

    Joined:
    Jun 13, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United States
    cPanel Access Level:
    Website Owner
    Thanks, found them, and good advice. I didn't know those were treated differently. I guess now, the only thing I'm wondering is why I have db's backed up at the account level when all I have is Entire MySQL Directory selected. If the backup backs ups databases per account anyway, then what's the point of having the different options that include "per account"?
     
    #3 Jimbo222, Jun 13, 2016
  4. twhiting9275

    twhiting9275 Well-Known Member

    Joined:
    Sep 26, 2002
    Messages:
    545
    Likes Received:
    15
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Twitter:
    As you mentioned, you don't have some databases assigned to an account, backing them up separately would be a good idea, of course. I'm not sure that using 'backup entire directory' is good, as it looks to be just backing up the binary files, which isn't really the best approach here.
     
    #4 twhiting9275, Jun 13, 2016
  5. Jimbo222

    Jimbo222 Registered

    Joined:
    Jun 13, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United States
    cPanel Access Level:
    Website Owner
    Yes, I follow. Thanks for your replies. I'm just confused on the backup configuration setting and why it would have the different options that include "per account" for database backup. In selecting the option "Entire MYSQL Directory", the backup script still backs up the databases in each account (per account) in .sql files. So I was just wondering the point of having options that include "per account" if it backs up the db's per account even if you choose the option that doesn't include "per account". What's the point?

    I guess what it means is backing up other mysql files not included in the mysqldump. I guess I was just confused on how they worded it in the WHM gui. Thanks.
     
    #5 Jimbo222, Jun 13, 2016
  6. twhiting9275

    twhiting9275 Well-Known Member

    Joined:
    Sep 26, 2002
    Messages:
    545
    Likes Received:
    15
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yeah, I agree, it is worded a bit odd.
     
    #6 twhiting9275, Jun 13, 2016
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,394
    Likes Received:
    1,212
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you verify if a remote MySQL server is utilized? Also, what version of cPanel is installed on the system?

    Thank you.
     
    #7 cPanelMichael, Jul 10, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - Entire MYSQL Directory
  1. Husseincak

    SOLVED Strange "MySQL" error that consumes my entire CPU

    Husseincak, Mar 16, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    311
    cPanelMichael
    Mar 17, 2017
  2. tnycman

    SOLVED Migrating the entire WHM to another server

    tnycman, Dec 28, 2016, in forum: Data Protection
    Replies:
    2
    Views:
    631
    cPanelMichael
    Jan 4, 2017
  3. Irwanto

    cPhulk blocked entire office

    Irwanto, Sep 18, 2016, in forum: Security
    Replies:
    1
    Views:
    299
    cPanelMichael
    Sep 22, 2016
  4. server948

    Deleted the entire sbin folder

    server948, Aug 6, 2016, in forum: General Discussion
    Replies:
    8
    Views:
    517
    twhiting9275
    Aug 8, 2016
  5. Reado

    Transferring entire cPanel server to another

    Reado, May 3, 2016, in forum: Data Protection
    Replies:
    2
    Views:
    722
    cPanelMichael
    May 4, 2016

Share This Page