Unable to backup my mysql database

ougogo

Well-Known Member
Dec 28, 2012
50
1
58
cPanel Access Level
Root Administrator
Hi,

I am unable to backup my mysql database using the Backups feature in cPanel.
I've severals database but they don't appear in Backups feature in cPanel.
But I'm able to backup my database with my resseller account.

I've already check permissions in my package configuration.

Any tips?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello :)

Are your databases listed under the "MySQL" area in cPanel? Also, do you notice any specific error messages in the cPanel error log (/usr/local/cpanel/logs/error_log) when you browse to the page that you referenced?

Thank you.
 

ougogo

Well-Known Member
Dec 28, 2012
50
1
58
cPanel Access Level
Root Administrator
Looks like a custom style to me. Try switching to the default style to see if its a style issue.
It is already the default style, with some disable options but not in relation with Mysql or databases.


Hello :)

Are your databases listed under the "MySQL" area in cPanel? Also, do you notice any specific error messages in the cPanel error log (/usr/local/cpanel/logs/error_log) when you browse to the page that you referenced?

Thank you.
Yes there are listed.
And no error about the page.


Best regards,
Hugo
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Please open a support ticket so we can take a closer look:

Submit A Ticket

You can post the ticket number here so we can update this thread with the outcome.

Thank you.
 

MatthewM.

Member
Jul 22, 2013
5
1
3
cPanel Access Level
Root Administrator
What happens when you just run a mysqldump? If you can login to SSH and run the following it may help determine the issue:

mysqldump horde > horde.sql

That'll make a backup of the horde database which is generally pretty small so it's good to test on.

If you run that and it presents errors post the full output here, I'll see if I can give some direction.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
To update, this was the result of invalid ownership on files associated with the account in the following directory:

Code:
/var/cpanel/databases/
The resolution was to update ownership of the files to "root:$username".

Thank you.