Backing Up External Databases Without Linked cPanel Accounts
Hello!
I have a main server where I host my cPanel accounts and perform backups using JetBackup without any issues.
However, I also use a secondary server (a node) dedicated solely to databases. Since this is an external server with no cPanel accounts associated with the hosted databases, I've noticed that the main server is unable to back up those databases — the backup files are returned empty, with no content.
Is there a way, using cPanel or JetBackup itself, to back up these databases even though they reside on a separate server and are not linked to any cPanel account?
-
Hey there! With my current understanding, no - on the local cPanel server in a typical configuration, each database is linked to a cPanel user, and that user is what processes the backup. Since these databases aren't connected to a cPanel user neither cPanel nor JetBackup would be able to include these through any normal backup routines.
You would be best backing these up separately on the node with a separate backup tool or even "mysqldump" to ensure you have copies of that data.
0 -
Alright!
Since cPanel natively only allows backups for existing accounts, I’ll need to discard that option in this case.
I have JetBackup installed on this node that hosts the databases. With it, would it be possible to configure a directory backup or something similar?
Could you provide more details on how I can back up these databases even if they’re not associated with a cPanel account?
I already do something similar on my email node, where I back up specific directories. Would this approach also work for databases?
Is there any official cPanel guide or documentation that explains how to handle this kind of setup?
Thank you in advance!
0 -
I'm in the same situation.
Following up...0 -
JetBackup would still want to associate these with a cPanel account.
I'm wondering...do the cPanel backups work on that system but it only ignores the databases since they are not related to a cPanel account? If so, could you not use the "Entire Data Directory" option in WHM >> Backup Configuration to achieve this?
0 -
No meu servidor principal, o Jetbackup faz backup de toda a conta.
No entanto, como o banco de dados é externo, o backup gerado é de um banco de dados vazio!
No servidor Node, uma vez que é um servidor especificamente para bancos de dados, não há contas.
Eu pensei sobre esta opção de fazê-lo por diretório, mas eu não sei se isso poderia causar quaisquer problemas, uma vez que ao selecionar esta opção, uma mensagem muito grande aparece informando que os dados podem estar corrompidos.
0 -
Since it's the only option you have that would be automatic, I'd try it. It wouldn't hurt any of the active data, but you'd want to verify the backup data after it completes to see if it works well in your situation.
0 -
Sure!
I'll run this test and validate how it will behave.
After success or failure, I'll come back here to report.
Thank you.
0 -
Sounds like a plan!
0
Please sign in to leave a comment.
Comments
8 comments