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.

Can't Get a mysql dump - due to roundcube - grrr

Discussion in 'Database Discussions' started by raindog308, Apr 24, 2012.

  1. raindog308

    raindog308 Member

    Joined:
    Apr 16, 2012
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Trying to do a dump of each database. cPanel 11.32 and it's pretty stock.

    Doing mysqldump for the database 'roundcube' gave me:

    Code:
    mysqldump: Got error: 1286: Unknown table engine 'InnoDB' when using LOCK TABLES
    Well, skip-innodb is set in /etc/my.cnf so no big surprise. Though enabling InnoDB just for roundcube...grrr...anyway, I enabled InnoDB. Then I got:

    Code:
    mysqldump: Got error: 1146: Table 'roundcube.cache' doesn't exist when using LOCK TABLES
    What?

    Code:
    mysql> show tables;
    +---------------------+
    | Tables_in_roundcube |
    +---------------------+
    | cache               |
    | contactgroupmembers |
    | contactgroups       |
    | contacts            |
    | cp_schema_version   |
    | identities          |
    | messages            |
    | session             |
    | users               |
    +---------------------+
    9 rows in set (0.00 sec)
    
    mysql> desc cache;
    ERROR 1146 (42S02): Table 'roundcube.cache' doesn't exist
    
    Nobody has used roundcube - literally the database has probably never modified because I haven't setup anyone yet. So the roundcube DB is exactly as it was setup.

    So...is roundcube just junk, is there a problem with cpanel, or...?
     
  2. NetMantis

    NetMantis BANNED

    Joined:
    Apr 22, 2012
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Utah
    cPanel Access Level:
    DataCenter Provider
    If "nobody uses roundcube", why are you trying to make a backup of that database?
     
  3. raindog308

    raindog308 Member

    Joined:
    Apr 16, 2012
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Nobody yet :)

    It just broke my "backup all databases" script.

    Solution was to drop the DB and run /usr/local/cpanel/bin/update-roundcube --force
     
Loading...

Share This Page