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.

Copy an account from another server with account password with PROBLEM

Discussion in 'Database Discussions' started by Parrue, Aug 20, 2013.

  1. Parrue

    Parrue Member

    Joined:
    Jun 29, 2011
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    51
    Hello,

    Can you help me, please?

    I am trying to copy some accounts and account transfers log appears this error:

    Storing mysql dbs...megatran_os_site.........
    megatran_os_site.tb_cadastro OK
    megatran_os_site.tb_ordem_servico OK
    megatran_os_site.usuarios
    Error : Incorrect information in file: './megatran_os_site/usuarios.frm'
    error : Corrupt

    if I run /scripts/pkgacct megatran, appears this error:

    Storing mysql dbs...megatran_os_site.........
    warn [pkgacct] megatran_os_site: mysqldump: Got error: 1286: Unknown storage engine 'InnoDB' when using LOCK TABLES

    /etc/my.cnf
    [mysqld]
    # safe-show-database
    old-passwords=1
    max_connections=500
    innodb_file_per_table=1
    default-storage-engine=MyISAM

    Tks,

    Joana
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    35,710
    Likes Received:
    1,139
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    The first error message indicates the database table listed is corrupt. You may want to try repairing that table before transferring the account. The second error message indicates that InnoDB is not enabled. Try restarting MySQL and check the MySQL error log (/var/lib/mysql/hostname.err). Look for any error messages related to InnoDB because it's possible InnoDB is not started due to corruption.

    Thank you.
     
  3. Parrue

    Parrue Member

    Joined:
    Jun 29, 2011
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    51
    Hello cPanelMichael,

    Thank you for your help,

    1 - to try to repair the database appears this error

    Code:
    Repairing megatran_os_site
    
    megatran_os_site.tb_cadastro                       OK
    megatran_os_site.tb_ordem_servico                  OK
    megatran_os_site.usuarios
    Error    : Unknown storage engine 'InnoDB'
    error    : Corrupt
    
    Done.
    2 - error log (/var/lib/mysql/hostname.err)

    Code:
    30821  8:17:02 [Note] /usr/sbin/mysqld: Shutdown complete
    
    130821 08:17:02 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended
    130821 08:17:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    130821  8:17:03 [Note] Plugin 'FEDERATED' is disabled.
    130821  8:17:03 InnoDB: The InnoDB memory heap is disabled
    130821  8:17:03 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
    130821  8:17:03 InnoDB: Compressed tables use zlib 1.2.3
    130821  8:17:03 InnoDB: Using Linux native AIO
    130821  8:17:03 InnoDB: Initializing buffer pool, size = 128.0M
    130821  8:17:03 InnoDB: Completed initialization of buffer pool
    InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
    InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
    InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
    130821  8:17:03 InnoDB: Could not open or create data files.
    130821  8:17:03 InnoDB: If you tried to add new data files, and it failed here,
    130821  8:17:03 InnoDB: you should now edit innodb_data_file_path in my.cnf back
    130821  8:17:03 InnoDB: to what it was, and remove the new ibdata files InnoDB created
    130821  8:17:03 InnoDB: in this failed attempt. InnoDB only wrote those files full of
    130821  8:17:03 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
    130821  8:17:03 InnoDB: remove old data files which contain your precious data!
    130821  8:17:03 [ERROR] Plugin 'InnoDB' init function returned error.
    130821  8:17:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    130821  8:17:03 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    130821  8:17:03 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    130821  8:17:03 [Note] Server socket created on IP: '0.0.0.0'.
    130821  8:17:03 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50096, now running 50530. Please use mysql_upgrade to fix this error.
    130821  8:17:03 [ERROR] mysql.user has no `Event_priv` column at position 29
    130821  8:17:03 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    130821  8:17:03 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.30-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    130821  8:17:41 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
    
    
    130821  7:28:15 [ERROR] Plugin 'InnoDB' init function returned error.
    130821  7:28:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    130821  7:28:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    130821  7:28:15 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    130821  7:28:15 [Note] Server socket created on IP: '0.0.0.0'.
    130821  7:28:15 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50096, now running 50530. Please use mysql_upgrade to fix this error.
    130821  7:28:15 [ERROR] mysql.user has no `Event_priv` column at position 29
    130821  7:28:15 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    130821  7:28:15 [Note] /usr/sbin/mysqld: ready for connections.
    Tks.
     
    #3 Parrue, Aug 21, 2013
    Last edited by a moderator: Aug 21, 2013
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    35,710
    Likes Received:
    1,139
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Check to see if you have any entries in the /etc/my.cnf file that alter the InnoDB configuration:

    Code:
    grep innodb /etc/my.cnf
    Also, do you have any recent backups of these databases? It's possible the databases that utilize InnoDB will need to be restored or repaired. Ideally, you should consult with a qualified system administrator to help assist you with ensuring no MySQL data is lost.

    Thank you.
     
  5. Parrue

    Parrue Member

    Joined:
    Jun 29, 2011
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    51
    Hello cPanelMichael,

    Thank you for your help,

    Problem solved.

    I deleted

    / var/lib/mysql/ibdata1
    / var/lib/mysql/ib_logfile0
    / var/lib/mysql/ib_logfile1

    and restart the Mysql,

    It worked now.
     
  6. Aaron.Edwards

    Aaron.Edwards Active Member

    Joined:
    Sep 21, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Please note that ibdata1, ib_logfile0 and ib_logfile1 are the three important files for a InnoDB storage engine related Tables in your mysql server. If you're sure about you mysql server doesn't have any tables with InnoDB Type, you can remove these file. But please note that InnoDB is much faster, recommended for highly transaction based databases.
     
Loading...

Share This Page