probiere ich gleich mal direkt aus
Beiträge von rekt
-
-
ich hatte 5.6 installiert wegen der sicherheitslücken in 5.5
-
Also zur erklärung ich habe gerade FreeBSD 11.0 frisch aufgesetzt hat auch super geklappt , hab mysql installiert wollte dann mein mysql backup vom Server einspielen und aufeinmal fängt der ganze Spaß an
ich habe natürlich vorher dem Ordner mysql 777 rechte erteilt und das gibt mir momentan der error log ausCode- 180308 10:42:31 mysqld_safe Logging to '/var/db/mysql/mope.err'.
- 180308 10:42:31 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2018-03-08 10:42:31 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2018-03-08 10:42:31 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.39) starting as process 1247 ...
- 2018-03-08 10:42:31 1247 [Note] Plugin 'FEDERATED' is disabled.
- /usr/local/libexec/mysqld: Unknown storage engine 'InnoDB'
- 2018-03-08 10:42:31 1247 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- 2018-03-08 10:42:31 1247 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2018-03-08 10:42:31 1247 [Note] InnoDB: The InnoDB memory heap is disabled
- 2018-03-08 10:42:31 1247 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2018-03-08 10:42:31 1247 [Note] InnoDB: Memory barrier is not used
- 2018-03-08 10:42:31 1247 [Note] InnoDB: Compressed tables use zlib 1.2.11
- 2018-03-08 10:42:31 1247 [Note] InnoDB: Using CPU crc32 instructions
- 2018-03-08 10:42:31 1247 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2018-03-08 10:42:31 1247 [Note] InnoDB: Completed initialization of buffer pool
- 2018-03-08 10:42:31 1247 [Note] InnoDB: Highest supported file format is Barracuda.
- InnoDB: No valid checkpoint found.
- InnoDB: If you are attempting downgrade from MySQL 5.7.9 or later,
- InnoDB: please refer to http://dev.mysql.com/doc/refman/5.6/en/upgrading-downgrading.html
- InnoDB: If this error appears when you are creating an InnoDB database,
- InnoDB: the problem may be that during an earlier attempt you managed
- InnoDB: to create the InnoDB data files, but log file creation failed.
- InnoDB: If that is the case, please refer to
- InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
- 2018-03-08 10:42:31 1247 [ERROR] Plugin 'InnoDB' init function returned error.
- 2018-03-08 10:42:31 1247 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
- 2018-03-08 10:42:31 1247 [ERROR] Unknown/unsupported storage engine: InnoDB
- 2018-03-08 10:42:31 1247 [ERROR] Aborting
- 2018-03-08 10:42:31 1247 [Note] Binlog end
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'partition'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_FT_DELETED'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_METRICS'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_CMPMEM'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_CMP_RESET'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_CMP'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_LOCKS'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'INNODB_TRX'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'BLACKHOLE'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'ARCHIVE'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'MRG_MYISAM'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'MyISAM'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'MEMORY'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'CSV'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'sha256_password'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'mysql_old_password'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'mysql_native_password'
- 2018-03-08 10:42:31 1247 [Note] Shutting down plugin 'binlog'
- 2018-03-08 10:42:31 1247 [Note] /usr/local/libexec/mysqld: Shutdown complete
- 180308 10:42:31 mysqld_safe mysqld from pid file /var/db/mysql/mope.pid ended
wäre nice wenn jemand ne Lösung für mich hat.