Copy an account from another server with account password with PROBLEM

[Parrue]

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

 

[cPanelMichael]

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.

 

[Parrue]

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.

Hello cPanelMichael,

Thank you for your help,

1 - to try to repair the database appears this error

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)

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.

 

[cPanelMichael]

Check to see if you have any entries in the /etc/my.cnf file that alter the InnoDB configuration:

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.

 

[Parrue]

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.

 

[Aaron.Edwards]

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.