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.

back up problem

Discussion in 'Database Discussions' started by AngelsGrave, Jul 15, 2013.

  1. AngelsGrave

    AngelsGrave Member

    Joined:
    May 11, 2012
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello

    i am going to get new server so i started to take a cpmove
    so i given that command :
    PHP:
    for i in `ls /var/cpanel/users`; do /scripts/pkgacct $i done
    and i got that errors when packing : :eek:

    Code:
    Determining mysql dbs...DBD::mysql::db selectall_arrayref failed: Incorrect information in file: './roundcube/users.frm' at /usr/local/cpanel/bin/cpmysqladmin line 200.
    DBD::mysql::db selectall_arrayref failed: Incorrect information in file: './roundcube/users.frm' at /usr/local/cpanel/bin/cpmysqladmin line 200.
    ...mysql version: 5.0......mysqldump version: 5.0...Saving mysql privs...Done
    ERROR 1033 (HY000) at line 1: Incorrect information in file: './horde/kronolith_shares.frm'
    ERROR 1033 (HY000) at line 1: Incorrect information in file: './horde/kronolith_shares.frm'
    ERROR 1033 (HY000) at line 1: Incorrect information in file: './roundcube/users.frm'
    ...Done
    
    Skipping Logaholic Backup. Logaholic is globally disabled on this system.
    
    Storing mysql dbs............
    banathi_games(43171819 bytes) horde.turba_objectswarn [pkgacct] horde.turba_objects: mysqldump: Got error: 1033: Incorrect information in file: './horde/turba_objects.frm' when doing LOCK TABLES
    
    horde.turba_objects
    Error    : Incorrect information in file: './horde/turba_objects.frm'
    error    : Corrupt
    warn [pkgacct] horde.turba_objects: mysqldump: Got error: 1033: Incorrect information in file: './horde/turba_objects.frm' when doing LOCK TABLES
    
    warn [pkgacct] horde: mysqldump failed -- database may be corrupt
    (753 bytes) warn [pkgacct] Failed to dump database horde
    horde.turba_shareswarn [pkgacct] horde.turba_shares: mysqldump: Got error: 1033: Incorrect information in file: './horde/turba_shares.frm' when doing LOCK TABLES
    
    horde.turba_shares
    Error    : Incorrect information in file: './horde/turba_shares.frm'
    error    : Corrupt
    warn [pkgacct] horde.turba_shares: mysqldump: Got error: 1033: Incorrect information in file: './horde/turba_shares.frm' when doing LOCK TABLES
    
    warn [pkgacct] horde: mysqldump failed -- database may be corrupt
    (753 bytes) warn [pkgacct] Failed to dump database horde
    horde.horde_prefswarn [pkgacct] horde.horde_prefs: mysqldump: Got error: 1033: Incorrect information in file: './horde/horde_prefs.frm' when doing LOCK TABLES
    
    horde.horde_prefs
    Error    : Incorrect information in file: './horde/horde_prefs.frm'
    error    : Corrupt
    warn [pkgacct] horde.horde_prefs: mysqldump: Got error: 1033: Incorrect information in file: './horde/horde_prefs.frm' when doing LOCK TABLES
    
    warn [pkgacct] horde: mysqldump failed -- database may be corrupt
    (753 bytes) warn [pkgacct] Failed to dump database horde
    horde.kronolith_shareswarn [pkgacct] horde.kronolith_shares: mysqldump: Got error: 1033: Incorrect information in file: './horde/kronolith_shares.frm' when doing LOCK TABLES
    
    horde.kronolith_shares
    Error    : Incorrect information in file: './horde/kronolith_shares.frm'
    error    : Corrupt
    warn [pkgacct] horde.kronolith_shares: mysqldump: Got error: 1033: Incorrect information in file: './horde/kronolith_shares.frm' when doing LOCK TABLES
    
    warn [pkgacct] horde: mysqldump failed -- database may be corrupt
    (753 bytes) warn [pkgacct] Failed to dump database horde
    horde.kronolith_storagewarn [pkgacct] horde.kronolith_storage: mysqldump: Got error: 1033: Incorrect information in file: './horde/kronolith_storage.frm' when doing LOCK TABLES
    
    horde.kronolith_storage
    Error    : Incorrect information in file: './horde/kronolith_storage.frm'
    error    : Corrupt
    warn [pkgacct] horde.kronolith_storage: mysqldump: Got error: 1033: Incorrect information in file: './horde/kronolith_storage.frm' when doing LOCK TABLES
    
    warn [pkgacct] horde: mysqldump failed -- database may be corrupt
    (753 bytes) warn [pkgacct] Failed to dump database horde
    horde.mnemo_memoswarn [pkgacct] horde.mnemo_memos: mysqldump: Got error: 1033: Incorrect information in file: './horde/mnemo_memos.frm' when doing LOCK TABLES
    
    horde.mnemo_memos
    Error    : Incorrect information in file: './horde/mnemo_memos.frm'
    error    : Corrupt
    warn [pkgacct] horde.mnemo_memos: mysqldump: Got error: 1033: Incorrect information in file: './horde/mnemo_memos.frm' when doing LOCK TABLES
    
    warn [pkgacct] horde: mysqldump failed -- database may be corrupt
    (753 bytes) warn [pkgacct] Failed to dump database horde
    horde.nag_taskswarn [pkgacct] horde.nag_tasks: mysqldump: Got error: 1033: Incorrect information in file: './horde/nag_tasks.frm' when doing LOCK TABLES
    
    horde.nag_tasks
    Error    : Incorrect information in file: './horde/nag_tasks.frm'
    error    : Corrupt
    warn [pkgacct] horde.nag_tasks: mysqldump: Got error: 1033: Incorrect information in file: './horde/nag_tasks.frm' when doing LOCK TABLES
    
    warn [pkgacct] horde: mysqldump failed -- database may be corrupt
    (753 bytes) warn [pkgacct] Failed to dump database horde
    
    ERROR: Failed to dump one or more databases
    ...Done
    
    then i tried the other command :

    PHP:
    /scripts/pkgacct
    and it gived me the same errors

    what do i do ?
    Help please :confused:
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    As per the provided logs, I can see your horde database is corrupted so I will suggest you try to reset full horde on your server, Try to run the following commands on your server

    Code:
    /scripts/fullhordereset
    /usr/local/cpanel/bin/update-horde –-force
    That will drop the existing horde database, and rebuild it. Then see if you can manually package that account.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The error messages you provided indicate the Horde and Roundcube databases may be corrupted. You can find information on repairing these databases at:

    How to Repair MyISAM Tables - MySQL 5.5
    How to Repair MyISAM Tables - MySQL 5.1

    Dropping the databases and reinstalling the Horde/Roundcube applications is also an option, but you will lose data stored in the those databases.

    Thank you.
     
  4. AngelsGrave

    AngelsGrave Member

    Joined:
    May 11, 2012
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for your help Michael ... the result :
    PS : there is many errors coz of the nginx in the end ... could it be the reason of that errors ??
    coz before the website goes down ( - link removed no need - ) there was 504 nginx error .


    Code:
    Updating Horde 1.2.11.cp7
    tar -x -p -z --no-same-owner -f /usr/local/cpanel/src/3rdparty/gpl/horde-webmail-1.2.11.tar.gz
    info [update-horde] Applied patch '0001-remove-test.php-files.patch'
    patching file imp/test.php
    patching file ingo/test.php
    patching file kronolith/test.php
    patching file lib/Horde/Kolab/Server/test.php
    patching file test.php
    patching file turba/test.php
    info [update-horde] Applied patch '0002-get-user-and-password-values-from-env.patch'
    patching file imp/lib/Compose.php
    patching file imp/lib/IMAP.php
    patching file imp/templates/login/login.html
    patching file templates/login/login.inc
    info [update-horde] Applied patch '0003-case-45312-height-directive-causing-text-to-disappea.patch'
    patching file themes/safari.css
    info [update-horde] Applied patch '0004-remove-apps-from-menu.patch'
    patching file dimp/config/conf.php
    info [update-horde] Applied patch '0005-use-driver-prefs.patch'
    patching file ingo/config/conf.php
    info [update-horde] Applied patch '0006-compare-applications-horde-webroot-with-current-URL.patch'
    patching file lib/Horde/Registry.php
    info [update-horde] Applied patch '0007-use-macro-for-database-creation.patch'
    patching file scripts/sql/groupware.mysql.sql
    info [update-horde] Applied patch '0008-set-server_name-as-localhost-and-from_addr-as-cpanel.patch'
    patching file kronolith/config/conf.php
    info [update-horde] Applied patch '0009-legacy-patch-disable-server_list-openssl-crt.patch'
    patching file imp/config/conf.php
    info [update-horde] Applied patch '0010-sanitize-preferences.patch'
    patching file lib/Horde/Prefs.php
    info [update-horde] Applied patch '0011-add-imap-and-default-config.patch'
    patching file config/conf.php.in
    patching file imp/config/servers.php.in
    info [update-horde] Applied patch '0012-Case-60020-Add-ie9-compatibility.patch'
    patching file dimp/lib/DIMP.php
    patching file imp/templates/common-header.inc
    patching file lib/Horde/Browser.php
    info [update-horde] Applied patch '0013-Fix-XSS-vulnerabilities-in-portal-blocks.patch'
    patching file kronolith/lib/Block/monthlist.php
    patching file kronolith/lib/Block/prevmonthlist.php
    info [update-horde] Applied patch '0014-Fix-empty-sorting-preferences.patch'
    patching file imp/lib/IMP.php
    info [update-horde] Successfully applied 14 patches
    Apply patchset to Horde sources
    Archiving current Horde data to /var/cpanel/horde/horde.backup.sql.1374003521
    mysqldump: Got error: 1033: Incorrect information in file: './horde/horde_alarms.frm' when using LOCK TABLES
    Failed to backup existing Horde DB. DB likely did not exist./usr/bin/mysqladmin: DROP DATABASE horde failed;
    error: 'Error on delete of './horde/nag_shares_groups.MYI' (Errcode: 2)'
    Cleaning old Horde data archives
    Creating Horde database
    ERROR 1007 (HY000) at line 48: Can't create database 'horde'; database exists
    Horde updated to 1.2.11.cp7
    No database backup found to restore.
    /usr/bin/IndexSrv-nginx-vhost-creator: line 7: /usr/local/nginx/conf/vhost.conf: No such file or directory
    /usr/bin/IndexSrv-nginx-vhost-creator: line 9: /usr/local/nginx/conf/vhost.conf: No such file or directory
    /usr/bin/IndexSrv-nginx-vhost-creator: line 22: /usr/local/nginx/conf/vhost.conf: No such file or directory
    /usr/bin/IndexSrv-nginx-vhost-creator: line 150: /usr/local/nginx/conf/vhost.conf: No such file or directory
    /usr/bin/IndexSrv-nginx-vhost-creator: line 176: /usr/local/nginx/conf/vhost.conf: No such file or directory
    
    Your horde password is above.  Horde has been reset
    root AT server.domain.com[~]# /usr/local/cpanel/bin/update-horde .-force
    Horde is up to date. Execute '/usr/local/cpanel/bin/update-horde --force' to force an update.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Did you try repairing the database first, or did you try the method offered by the other poster? The error log indicates the database is still corrupted. You will need to try repairing it, or back it up and delete it before attempting to reinstall Horde.

    Thank you.
     
  6. AngelsGrave

    AngelsGrave Member

    Joined:
    May 11, 2012
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    i am very very sorry but i am not that strong in shell ... would you please give me a moment and tell me what to do :$
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You can check to see which version of MySQL is installed on your system with the following command:

    Code:
    mysql -V
    Then, you can follow the appropriate guide for repairing the databases:

    How to Repair MyISAM Tables - MySQL 5.5
    How to Repair MyISAM Tables - MySQL 5.1

    If you prefer to completely delete your Horde/Roundcube databases (and lose user configured data for those webmail applications), you can drop them via PHPMyAdmin and then run:

    Code:
    /usr/local/cpanel/bin/update-horde --force
    /usr/local/cpanel/bin/update-roundcube --force
    
    Thank you.
     
  8. AngelsGrave

    AngelsGrave Member

    Joined:
    May 11, 2012
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Really thanks for helping me out

    this have been done after opening a ticket to CPanel support and they did fix it ... thanks aloooooooooooot for this :)
     
Loading...

Share This Page