Page 1 of 2 12 LastLast
Results 1 to 15 of 27

Thread: mysql backup from cpanel

  1. #1
    Registered Member upsforum's Avatar
    Join Date
    Jul 2005
    Posts
    380

    Default mysql backup from cpanel

    from my cpanel if click on "Download a MySQL Database Backup", in Backup area, the file tar result is empty, I restart cpanel all service but don't work

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

    Root Administrator

    Default

    Quote Originally Posted by upsforum View Post
    from my cpanel if click on "Download a MySQL Database Backup", in Backup area, the file tar result is empty, I restart cpanel all service but don't work
    You must login as the user (not as a reseller or root) to use this functionality. Logging in as reseller/root will produce the behavior you mention.

  3. #3
    Technical Product Specialist cPanelDavidG's Avatar
    Join Date
    Nov 2006
    Location
    Houston, TX
    Posts
    11,289
    cPanel Access Level

    Root Administrator

    Default

    Quote Originally Posted by upsforum View Post
    I try with user but I get this empty file


    -- MySQL dump 10.9
    --
    -- Host: localhost Database: dbname
    -- ------------------------------------------------------
    -- Server version 4.1.22-standard

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    If you are logging in with both the user's username and that user's password (not the reseller's password), that should not happen. I recommend having one of our technical analysts take a look at this for you: http://tickets.cpanel.net/submit

  4. #4
    Registered Member upsforum's Avatar
    Join Date
    Jul 2005
    Posts
    380

    Default

    I try with user but I get this empty file


    -- MySQL dump 10.9
    --
    -- Host: localhost Database: dbname
    -- ------------------------------------------------------
    -- Server version 4.1.22-standard

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

  5. #5
    Registered User
    Join Date
    Nov 2008
    Posts
    1

    Default

    Quote Originally Posted by cPanelDavidG View Post
    You must login as the user (not as a reseller or root) to use this functionality. Logging in as reseller/root will produce the behavior you mention.
    May I ask why this is the case? As a reselller with a virtual server with dozens of accounts, it will take about 58987% longer to login and out as each individual user to backup their dbs.

    It would be great to be able to be logged in as the reseller and backup all my client's dbs under one session.

  6. #6
    Registered Member
    Join Date
    Dec 2007
    Posts
    16

    Default

    I fully agree!

    Quote Originally Posted by mediaguru View Post
    May I ask why this is the case? As a reselller with a virtual server with dozens of accounts, it will take about 58987% longer to login and out as each individual user to backup their dbs.

    It would be great to be able to be logged in as the reseller and backup all my client's dbs under one session.

  7. #7
    cPanel Development cPanelKenneth's Avatar
    Join Date
    Apr 2006
    Posts
    4,286
    cPanel Access Level

    Root Administrator

    Default

    The reseller does not have access to the user's MySQL password.

  8. #8
    Registered Member
    Join Date
    Jun 2007
    Posts
    217
    cPanel Access Level

    DataCenter Provider

    Default

    Quote Originally Posted by cpanelkenneth View Post
    The reseller does not have access to the user's MySQL password.
    This is apparently a bug in the Backup Wizard vs Backup. If you use the Backup Wizard, the SQL dumps are empty. If you use Backup, they are fine...

    I've tested this with about 3 different sites on 3 different cPanel servers.

    Just an FYI to those here and to the cPanel team that this needs to be corrected.

  9. #9
    cPanel Development cPanelKenneth's Avatar
    Join Date
    Apr 2006
    Posts
    4,286
    cPanel Access Level

    Root Administrator

    Default

    Quote Originally Posted by gkgcpanel View Post
    This is apparently a bug in the Backup Wizard vs Backup. If you use the Backup Wizard, the SQL dumps are empty. If you use Backup, they are fine...

    I've tested this with about 3 different sites on 3 different cPanel servers.

    Just an FYI to those here and to the cPanel team that this needs to be corrected.
    Are you performing your tests logged in directly as the user, or logged in as the reseller?

    As the user, I'm not able to replicate what you are reporting with either 11.24.5-CURRENT_38506 or 11.25.0-BETA_39475

    Using either the Backup or the Backup Wizard interface to download a MySQL backup results in complete dump of the database selected.

    When attempting the same as the reseller, using either of the above versions of cPanel, I receive an error message stating I need to create /home/user/.my.cnf
    Kenneth
    Development
    cPanel, Inc.

  10. #10
    EWD
    EWD is offline
    Registered Member cPanel Partner NOC Badge
    Join Date
    Aug 2003
    Location
    NY
    Posts
    167

    Default

    cPanel 11.24.5-R38506 - WHM 11.24.2 - X 3.9
    CENTOS 5.3 x86_64

    I am seeing this logged in as a user.
    Login to cpanel
    Click on backups
    Click on Database name to download file.
    File downloads but it is empty.
    Emerson

  11. #11
    Registered Member
    Join Date
    Jun 2007
    Posts
    217
    cPanel Access Level

    DataCenter Provider

    Default

    Quote Originally Posted by cpanelkenneth View Post
    Are you performing your tests logged in directly as the user, or logged in as the reseller?

    As the user, I'm not able to replicate what you are reporting with either 11.24.5-CURRENT_38506 or 11.25.0-BETA_39475

    Using either the Backup or the Backup Wizard interface to download a MySQL backup results in complete dump of the database selected.

    When attempting the same as the reseller, using either of the above versions of cPanel, I receive an error message stating I need to create /home/user/.my.cnf

    The user themselves reported this and they are logged in as themselves. I logged in as the user and I can duplicate this every time.

    I also logged in from my WHM (list users, find the user in question, click on the cPanel logo to get to their cPanel) and the same issue occurs. With BackupWizard the dump file is empty with 20K (within the tar.gz file) and with Backup, it's fine, 12.1 MB (within the tar.gz file).

    My support team also does not have access to whm, they have to obtain the users cPanel username/password and they log in as the user and they can also duplicate the same situation.

  12. #12
    Technical Product Specialist cPanelDavidG's Avatar
    Join Date
    Nov 2006
    Location
    Houston, TX
    Posts
    11,289
    cPanel Access Level

    Root Administrator

    Default

    Quote Originally Posted by gkgcpanel View Post
    The user themselves reported this and they are logged in as themselves. I logged in as the user and I can duplicate this every time.

    I also logged in from my WHM (list users, find the user in question, click on the cPanel logo to get to their cPanel) and the same issue occurs. With BackupWizard the dump file is empty with 20K (within the tar.gz file) and with Backup, it's fine, 12.1 MB (within the tar.gz file).

    My support team also does not have access to whm, they have to obtain the users cPanel username/password and they log in as the user and they can also duplicate the same situation.
    I recommend you notify whoever has root access to the server about this issue so they can contact our technical analysts and have them take a look at this for you.

  13. #13
    Registered Member
    Join Date
    Jul 2006
    Posts
    292

    Default

    Quote Originally Posted by gkgcpanel View Post
    This is apparently a bug in the Backup Wizard vs Backup. If you use the Backup Wizard, the SQL dumps are empty. If you use Backup, they are fine...

    I've tested this with about 3 different sites on 3 different cPanel servers.

    Just an FYI to those here and to the cPanel team that this needs to be corrected.
    Hi there,

    I am experiencing this issue as well, a backup created through the backup wizard is corrupt, however, a backup through the normal Backup option creates the proper backup.

  14. #14
    Registered Member
    Join Date
    Jul 2006
    Posts
    292

    Default

    Ok, an update. The user had changed their main account password, however, the .my.cnf file located within the users directory, had not updated the password. To correct the issue, I moved the existing .my.cnf file, to .my.cnf.backup, thus forcing cPanel to recreated this file with the correct password.

    From shell:

    mv /home/user/.my.cnf /home/user/my.cnf.backup

    Then, have the user log into cPanel again, or, if you know the users password, you can log in with it. Once completed, you should be able to download sql backups.
    Last edited by ChrisRHS; 10-04-2009 at 05:39 PM.

  15. #15
    Registered Member
    Join Date
    Jun 2007
    Posts
    217
    cPanel Access Level

    DataCenter Provider

    Default no such file...

    Quote Originally Posted by ChrisRHS View Post
    Ok, an update. The user had changed their main account password, however, the .my.cnf file located within the users directory, had not updated the password. To correct the issue, I moved the existing .my.cnf file, to .my.cnf.backup, thus forcing cPanel to recreated this file with the correct password.

    From shell:

    mv /home/user/.my.cnf /home/user/my.cnf.backup

    Then, have the user log into cPanel again, or, if you know the users password, you can log in with it. Once completed, you should be able to download sql backups.
    I logged in and there is no such file .my.cnf in any of my users home directories.. I have the main one under root, but those that I checked, don't have a file named like that.

Page 1 of 2 12 LastLast

Similar Threads

  1. mysql backup from cpanel
    By upsforum in forum General Discussion
    Replies: 21
    Last Post: 08-04-2010, 11:30 AM
  2. Replies: 1
    Last Post: 01-18-2008, 10:44 AM
  3. How to disable mysql backup using cpanel backup
    By oumind in forum General Discussion
    Replies: 1
    Last Post: 05-16-2007, 10:49 PM
  4. Backup MySql (dump) from CPANEl and phpmyadm are different
    By Cristian99 in forum General Discussion
    Replies: 0
    Last Post: 07-03-2006, 06:16 AM
  5. Cpanel Backup with Mysql/Mailing List etc.
    By v2webltd in forum E-mail Discussions
    Replies: 1
    Last Post: 05-08-2002, 01:48 PM
bargain