Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 8 of 8
  1. #1
    Member
    Join Date
    Feb 2009
    Posts
    35
    cPanel/Enkompass Access Level

    Root Administrator

    Default Downloading a MySQL backup issue

    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

  2. #2
    Technical Product Specialist cPanelDavidG's Avatar
    Join Date
    Nov 2006
    Location
    Houston, TX
    Posts
    11,189
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    Quote Originally Posted by D-Litz View Post
    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?

  3. #3
    Member
    Join Date
    Feb 2009
    Posts
    35
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    Quote Originally Posted by cPanelDavidG View Post
    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.

  4. #4
    Member
    Join Date
    Feb 2009
    Posts
    35
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    Forgot to add that we do not have any reseller accounts on any of our servers...

    All accounts are under root.

  5. #5
    Technical Product Specialist cPanelDavidG's Avatar
    Join Date
    Nov 2006
    Location
    Houston, TX
    Posts
    11,189
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    Are you accessing phpMyAdmin via cPanel or via WHM?

    Additionally, are you logged into cPanel as the user with their password, or with your root password?

  6. #6
    Member
    Join Date
    Feb 2009
    Posts
    35
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    Quote Originally Posted by cPanelDavidG View Post
    Are you accessing phpMyAdmin via cPanel or via WHM?

    Additionally, are you logged into cPanel as the user with their password, or with your root password?
    I am accessing it via cPanel and using the end user login info

    http://domain.com:2082/frontend/x3/index.html

  7. #7
    Technical Product Specialist cPanelDavidG's Avatar
    Join Date
    Nov 2006
    Location
    Houston, TX
    Posts
    11,189
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    Quote Originally Posted by D-Litz View Post
    I am accessing it via cPanel and using the end user login info

    http://domain.com:2082/frontend/x3/index.html
    In that case, I recommend letting our technical analysts assist you with determining the cause of this issue and resolution of this issue.

  8. #8
    Member
    Join Date
    Oct 2009
    Posts
    5

    Smile

    Quote Originally Posted by D-Litz View Post
    I am accessing it via cPanel and using the end user login info

    http://domain.com:2082/frontend/x3/index.html

    Yes, i also face some time same problem, but mostly its due to that database is not selected, i just download a php file, after selecting proper database and complete inserts, i never see such problems.

Similar Threads & Tags
Similar threads

  1. Automated MySQL backup issue
    By techpro in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 03-18-2011, 08:34 AM
  2. mysql backup issue
    By bhanuprasad1981 in forum Data Protection
    Replies: 6
    Last Post: 08-22-2009, 02:32 AM
  3. downloading a home Backup finishes prematurely.
    By hbidad in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 10-15-2008, 10:38 PM
  4. Replies: 1
    Last Post: 01-18-2008, 09:44 AM
  5. Downloading backup does not become complete
    By Mehrpou in forum Data Protection
    Replies: 2
    Last Post: 12-11-2007, 03:05 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube