Database backup Per account only

[joaowall]

Hi guys, I configured the database backup in whm and selected the "Per Account Only" option. After the backup is complete, where are the .sql files stored?

 

[quietFinn]

If it's a compressed backup the .sql files are in <cPanelUsername>mysql/

 

[cPRex]

To expand on @quietFinn's answer, normally the backup files are stored in the following location on the server:

/backup/2022-01-24/accounts

In that directory, you'll find username.tar.gz files, which is the backup of the account. The database content will be zipped in the account, and when unzipped will be located in the username/mysql directory.

 

[joaowall]

Hi @cPRex , I checked /backup/[date]/accounts folder and it is empty.

System backup is ok.

Do you have any suggestions as to what might be happening?

 

[cPRex]

Do you have any accounts included in the backups? inside WHM >> Backup Configuration, under the "Files" section, there is a "Backup Users" button. If you click that, do you show that users are selected? If not, you may only have system data being backed up.

 

[joaowall]

Do you have any accounts included in the backups? inside WHM >> Backup Configuration, under the "Files" section, there is a "Backup Users" button. If you click that, do you show that users are selected? If not, you may only have system data being backed up.

I think that was the problem, I will select the user and test again. Thanks a lot for the help.

 

[cPRex]

Sure thing! If the user isn't selected there, that user will not be included in the nightly backups.