mysql - How do I restore innodb-files into an sql file and that's it? - Ask Ubuntu

i trying restore innodb databases files. followed

1. stop mysql daemon/service (# services stop mysql) on mine services.msc , made sure mysql service not running.
2. replace new “data” directory backed-up 1 (don’t forget work on copy of backup, , not 1 , backup!!)
3. start mysqld innodb revocery parameters, , keep windows open: mysqld --standalone --console --innodb-force-recovery=4. console stay open , you’ll see log messages directly on screen (ctrl-c close server), came across number of problem please see after step 7 have copied & pasted output recovery.

and entered sudo -u mysql mysqld --standalone --console --explicit_defaults_for_timestamp --innodb-force-recovery=4 , got

2016-10-21t04:56:01.469769z 0 [warning] changed limits: max_open_files: 1024 (requested 5000) 2016-10-21t04:56:01.469808z 0 [warning] changed limits: table_open_cache: 431 (requested 2000) 2016-10-21t04:56:01.608783z 0 [note] mysqld (mysqld 5.7.15-0ubuntu2) starting process 21945 ... 2016-10-21t04:56:01.611402z 0 [note] innodb: punch hole support available 2016-10-21t04:56:01.611455z 0 [note] innodb: mutexes , rw_locks use gcc atomic builtins 2016-10-21t04:56:01.611514z 0 [note] innodb: uses event mutexes 2016-10-21t04:56:01.611551z 0 [note] innodb: gcc builtin __atomic_thread_fence() used memory barrier 2016-10-21t04:56:01.611586z 0 [note] innodb: compressed tables use zlib 1.2.8 2016-10-21t04:56:01.611620z 0 [note] innodb: using linux native aio 2016-10-21t04:56:01.611798z 0 [note] innodb: number of pools: 1 2016-10-21t04:56:01.611903z 0 [note] innodb: using cpu crc32 instructions 2016-10-21t04:56:01.612745z 0 [note] innodb: initializing buffer pool, total size = 128m, instances = 1, chunk size = 128m 2016-10-21t04:56:01.617639z 0 [note] innodb: completed initialization of buffer pool 2016-10-21t04:56:01.618798z 0 [note] innodb: if mysqld execution user authorized, page cleaner thread priority can changed. see man page of setpriority(). 2016-10-21t04:56:01.630251z 0 [note] innodb: highest supported file format barracuda. 2016-10-21t04:56:01.630414z 0 [error] innodb: upgrade after crash not supported. redo log created before mysql 5.7.9, , appears corrupted. please follow instructions @ http://dev.mysql.com/doc/refman/5.7/en/upgrading.html 2016-10-21t04:56:01.630461z 0 [error] innodb: plugin initialization aborted error generic error 2016-10-21t04:56:02.232149z 0 [error] plugin 'innodb' init function returned error. 2016-10-21t04:56:02.232182z 0 [error] plugin 'innodb' registration storage engine failed. 2016-10-21t04:56:02.232190z 0 [error] failed initialize plugins. 2016-10-21t04:56:02.232195z 0 [error] aborting  2016-10-21t04:56:02.232201z 0 [note] binlog end 2016-10-21t04:56:02.232251z 0 [note] shutting down plugin 'csv' 2016-10-21t04:56:02.232586z 0 [note] mysqld: shutdown complete 

yet don't want upgrade restore files sql file. how restore files sql file , that's it?

edit: --innodb-force-recovery=6 solved it, how intuitive.