Downloading a MySQL backup issue

D-Litz

Active Member
Feb 4, 2009
35
0
56
cPanel Access Level
Root Administrator
What would cause a backup from the built in MySQL backup function to only be 1 byte?

Downloading the same sql file via PHPMyAdmin works just fine.

Thanks
 

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,216
12
313
Houston, TX
cPanel Access Level
Root Administrator
What would cause a backup from the built in MySQL backup function to only be 1 byte?

Downloading the same sql file via PHPMyAdmin works just fine.

Thanks
In the past, that would be caused by attempting to create a backup while logged into the cPanel interface using the reseller override feature. Since the reseller had no access to the database, the resulting backup file was much smaller than it should have been.

In the latest versions of cPanel/WHM, the interface will notify you about this situation (if logged in using reseller override) before you generate a bad backup. However, this condition also prevents access to phpMyAdmin via cPanel.

Are you accessing phpMyAdmin via cPanel or via WHM?
 

D-Litz

Active Member
Feb 4, 2009
35
0
56
cPanel Access Level
Root Administrator
In the past, that would be caused by attempting to create a backup while logged into the cPanel interface using the reseller override feature. Since the reseller had no access to the database, the resulting backup file was much smaller than it should have been.

In the latest versions of cPanel/WHM, the interface will notify you about this situation (if logged in using reseller override) before you generate a bad backup. However, this condition also prevents access to phpMyAdmin via cPanel.

Are you accessing phpMyAdmin via cPanel or via WHM?


The problem is with cpanel>backups>Download a MySQL Database Backup>Pick a database to download.

the download begins...but when it saves, its only 1byte in size.

In phpmyadmin, I just use the export feature and get the database that way...however the Backup>Download a MySQL Database Backup is broken.