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!

Incremental backup question/problem

Discussion in 'General Discussion' started by n000b, Aug 20, 2009.

  1. n000b

    n000b Well-Known Member

    Joined:
    Apr 7, 2005
    Messages:
    142
    Likes Received:
    0
    Trophy Points:
    166
    On one of my servers I run weekly incremental backups for all accounts on the server. I had to restore some data from one of the backups tonight and I noticed something that concerned me. Here is the backup directory of one of my users:

    Code:
    root@twirl [/backup/cpbackup/weekly/bubba]# ls -al
    total 148
    drwxr-x---  27 root bubba  4096 Jul 27 01:29 ./
    drwx--x--x 382 root root  12288 Aug 18 11:18 ../
    -rw-------   1 root root      0 Jul 27 01:29 addons
    drwx------   2 root root   4096 Aug 12 01:51 bandwidth/
    drwx------   2 root root   4096 Jul 27 01:29 counters/
    drwx------   2 root root   4096 Aug 12 01:52 cp/
    drwx------   2 root root   4096 Jul 27 01:29 cron/
    drwx------   2 root root   4096 Jul 27 01:29 dnszones/
    drwx------   2 root root   4096 Jul 27 01:29 fp/
    drwx------  16 root root   4096 Aug 12 01:51 homedir/
    -rw-------   1 root root     12 Jul 27 01:29 homedir_paths
    drwx------   2 root root   4096 Jul 27 01:29 httpfiles/
    drwx------   2 root root   4096 Jul 27 01:29 interchange/
    drwx------   2 root root   4096 Jul 27 01:29 logs/
    drwx------   2 root root   4096 Jul 27 01:29 meta/
    drwx------   2 root root   4096 Jul 27 01:29 mm/
    drwx------   4 root root   4096 Jul 27 01:29 mma/
    drwx------   2 root root   4096 Jul 27 01:29 mms/
    drwx------   2 root root   4096 Jul 29 05:32 mysql/
    -rw-------   1 root root    531 Jul 27 01:29 mysql.sql
    -rw-------   1 root root      0 Jul 27 01:29 nobodyfiles
    -rw-------   1 root root     15 Jul 27 01:29 pds
    -rw-------   1 root root    176 Jul 26 23:21 proftpdpasswd
    drwx------   2 root root   4096 Jul 27 01:29 psql/
    -rw-------   1 root root      3 Jul 27 01:29 quota
    drwx------   2 root root   4096 Jul 27 01:29 resellerconfig/
    -rw-------   1 root root      0 Jul 27 01:29 sds
    -rw-------   1 root root      0 Jul 27 01:29 sds2
    -rw-------   1 root root     34 Jul 27 01:29 shadow
    -rw-------   1 root root     29 Jul 27 01:29 shell
    drwx------   2 root root   4096 Jul 27 01:29 sslcerts/
    -rw-------   1 root root      0 Jul 27 01:29 ssldomain
    drwx------   2 root root   4096 Jul 27 01:29 sslkeys/
    drwx------   2 root root   4096 Jul 27 01:29 suspended/
    drwx------   2 root root   4096 Jul 27 01:29 suspendedinfo/
    drwx------   2 root root   4096 Aug  5 01:46 userdata/
    drwx------   2 root root   4096 Jul 27 01:29 va/
    drwx------   2 root root   4096 Jul 27 01:29 vad/
    -rw-r--r--   1 root root     40 Aug 12 01:51 version
    drwx------   2 root root   4096 Jul 27 01:29 vf/
    
    Note the timestamp on most of the files is July 27th. I understand that it would only backup files that have changed, but I added a user through cPanel to this account since after July 27th and before the last backup has run and it has not updated the mysql.sql file as there was a user missing from here.

    Is cPanel supposed to update the mysql.sql file if a user has been added/modified/deleted from MySQL?
     
  2. n000b

    n000b Well-Known Member

    Joined:
    Apr 7, 2005
    Messages:
    142
    Likes Received:
    0
    Trophy Points:
    166
Loading...

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.
    Dismiss Notice