How to set Legacy system to only backup MySql databases

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

 

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

 

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