i am trying to recover mysql database , but no success.
the error message i get in the user.err file
190709 12:28:14 [Note] Plugin 'FEDERATED' is disabled. 190709 12:28:14 InnoDB: The InnoDB memory heap is disabled 190709 12:28:14 InnoDB: Mutexes and rw_locks use Windows interlocked functions 190709 12:28:14 InnoDB: Compressed tables use zlib 1.2.3 190709 12:28:14 InnoDB: Initializing buffer pool, size = 128.0M 190709 12:28:14 InnoDB: Completed initialization of buffer pool InnoDB: Error: auto-extending data file .\ibdata1 is of a different size InnoDB: 64 pages (rounded down to MB) than specified in the .cnf file: InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages! 190709 12:28:14 InnoDB: Could not open or create data files. 190709 12:28:14 InnoDB: If you tried to add new data files, and it failed here, 190709 12:28:14 InnoDB: you should now edit innodb_data_file_path in my.cnf back 190709 12:28:14 InnoDB: to what it was, and remove the new ibdata files InnoDB created 190709 12:28:14 InnoDB: in this failed attempt. InnoDB only wrote those files full of 190709 12:28:14 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 190709 12:28:14 InnoDB: remove old data files which contain your precious data! 190709 12:28:14 [ERROR] Plugin 'InnoDB' init function returned error. 190709 12:28:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 190709 12:28:14 [ERROR] Unknown/unsupported storage engine: INNODB 190709 12:28:14 [ERROR] Aborting
what i tried
- installed mysql in another computer with same path as crashed database
- created an empty database with same name as old.
- stopped mysql service in new computer
- backup files in new computer mysql/data
- copied old files ib_logfile0,ib_logfile1, and ibdata1 to new computer mysql/data directory
- start mysql in new computer
i get the error message