The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysqlhotcopy broken?

Discussion in 'General Discussion' started by erick_paper, Mar 7, 2007.

  1. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
    Anyone else experiencing problems with mysqlhotcopy suddenly??

    Our backup was running without any problems for couple of months now. Last night, out of the blue, it started giving this invalid db.table name error.

    The DB structure or config hasn't changed since last successful backup. Here is the full error:

    ERROR: Output of command:
    'mysqlhotcopy' is {
    Invalid db.table name 'my_db.my_db`.`first_table' at /usr/bin/mysqlhotcopy line 854.
    }

    OS: CentOS 4.4
    MySQL: 5.0.27
    mysqlhotcopy v1.22


    I'm not sure if it's normal for it to list the database name twice.Anyone have an idea on what could be wrong?

    Thanks!
     
  2. brainmass

    brainmass Registered

    Joined:
    Oct 22, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Having the same problem, it was working fine until last Sunday.

    I checked the logs and it looks like DBD:mysql was updated the night before the first time it started to generate the error. Not sure if it's just a coincidence but nothing else has changed.

    Same setup as yours, RHEL4


    shell>mysqlhotcopy my_db my_db_bk
    Invalid db.table name 'my_db.my_db`.`table1' at /usr/bin/mysqlhotcopy line 854.


    Not sure why it's doubling up the database name, must be part of whats causing the problem.
     
  3. Scott.Mc

    Scott.Mc Member

    Joined:
    Feb 22, 2006
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Temporary rolling back will fix it.

    cd /usr/local/src;wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.001.tar.gz;tar -zxvf DBD-mysql-4.001.tar.gz;cd DBD-mysql-4.001;perl Makefile.PL;make;make install

    If you want to use 4.003 again just run /scripts/perlinstaller --force Bundle::DBD::mysql , mysqlhotcopy seems to work when you reinstall 4.003 that way or using the above(4.001)
     
    #3 Scott.Mc, Mar 8, 2007
    Last edited: Mar 8, 2007
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Thanks for that info. I'll see what we can do about it.
     
  5. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16

    Thanks for this tip. At least this seems to have done something! But I now have a new error:

    What reload privilege? This used to work as it is! If it is connecting as root user, of course the root user has the privilege. Any idea?
     
  6. nsusa

    nsusa Well-Known Member

    Joined:
    Jun 30, 2004
    Messages:
    93
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Colorado, USA
    When can we expect a permanent fix?

    Chris
     
  7. 63bus

    63bus Active Member

    Joined:
    Mar 31, 2007
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Any word on this? My backup started breaking when 4.004 was installed automatically.

    A rollback to 4.001 works using the commands above but 4.004 just gets installed again the next night.

    The forcebundle install did not work for me - only a rollback worked.
     
  8. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
    Is Cpanel even aware of this? Mysqlhotcopy plays a *very* important part in the db backup strategy of many hosts and for it to be broken for as long as it has been is outrageous. Could someone please tell me where I can raise this (those "bug tickets" thingies)?

    Thanks.
     
  9. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    I performed a search on our feature request/bug reporting system and found no matches for Mysqlhotcopy. I would recommend someone familiar with this situation post a bug report to:

    http://bugzilla.cpanel.net

    This will allow our developers to know that there is an ongoing issue that needs to be fixed. Once you submit the bug, please post a link to the bug here so others can vote for the bug or add themselves as CC so they can receive updates via email.
     
  10. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
  11. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page