How to set Legacy system to only backup MySql databases

Simplyfriday

• June 29, 2015 14:37

I am running a VPS hosted server with root access. I have two databases that I need to backup - a wordpress database and a forums database. I have been using the legacy system to backup the entire server and then using S3BackupWHM to move the backup over to an S3 account. Because we hold a lot of audio / visual files on the server the resulting .tar.gz was over 39 Gig. It ended up utilizing so much resource that the server started throwing off lots of different errors so I halted the process. I have now got a full backup of the entire AV files and going forward am loading new AV files direct to S3. So - right now - I only need to back up the MySql databases - not the entire account. My question is - how do I setup the legacy system to only backup the mysql databases and ignore the other directories? Thank you, Andrew

• 

  Infopro

  • June 29, 2015 20:00

  The docs may be useful to you:

  0
• 

  Simplyfriday

  • July 06, 2015 18:48

  Thank you - I've read the docs and they make sense - I have a couple of questions on syntax if you could possibly give it a once over. So the cpbackup-exclude.conf comes has the following files already in there: */.wysiwygPro_* */core.[0-9]+$ .MirrorSearch .cpan .cpanel/caches .cpanel/datastore .cpcpan .sqmailattach access-logs public_ftp/.ftpquota When I use Filezilla to ftp into my server the Remote site address of the directory I wish to exclude is: /home/username/public_html/board My first question is - do I add the address just like that? I ask because .cpan and .cpcpan sit inside the home directory so maybe I should add it as: .username/public_html/board My second question is that I have two additional accounts (usernames) within the home directory that I was using for build and test sites. I don't need either of them backed up. So can I add the following: /home/usernametest /home/usernamebuild or would it be: .usernametest .usernamebuild Thank you very much, Andrew

  0
• 

  Infopro

  • July 06, 2015 19:49

  You wouldn't add a dot to an existing directory name. Any directory with a dot in its name already, like .cpan, is for the system. In most cases, you wouldn't have a need to even see them. That is unless you're editing your .htaccess file for some reason, for example. These dot files can be hidden from view. This thread may be of some use in answering both your questions:

  0
• 

  Simplyfriday

  • July 13, 2015 17:39

  Thank you very much for the insight= very much appreciated and yes - I'll go and practice on a baby account! Have a great week

  0

Please sign in to leave a comment.