Um es kurz zu machen gibt mir meine Mysql folgenden Error aus
Code
- 161229 12:37:51 mysqld_safe mysqld from pid file /var/db/mysql/MetinSource.pid ended
- 161229 12:37:51 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2016-12-29 12:37:51 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
- 2016-12-29 12:37:51 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.34) starting as process 3110 ...
- 2016-12-29 12:37:52 3110 [Note] Plugin 'FEDERATED' is disabled.
- 2016-12-29 12:37:52 3110 [Warning] Using unique option prefix innodb_buffer_pool_instance instead of innodb-buffer-pool-instances is deprecated and will be removed in a future release. Please use the full name instead.
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2016-12-29 12:37:52 3110 [Note] InnoDB: The InnoDB memory heap is disabled
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Memory barrier is not used
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Compressed tables use zlib 1.2.3
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Using CPU crc32 instructions
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Initializing buffer pool, size = 4.0G
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Completed initialization of buffer pool
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Highest supported file format is Barracuda.
- 2016-12-29 12:37:52 802816000 InnoDB: Operating system error number 2 in a file operation.
- InnoDB: The error means the system cannot find the path specified.
- InnoDB: If you are installing InnoDB, remember that you must create
- InnoDB: directories yourself, InnoDB does not create them.
- 2016-12-29 12:37:52 3110 [ERROR] InnoDB: Could not find a valid tablespace file for 'player/offline_shop_npc'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
- 2016-12-29 12:37:52 3110 [ERROR] InnoDB: Tablespace open failed for '"player"."offline_shop_npc"', ignored.
- 2016-12-29 12:37:52 3110 [Note] InnoDB: 128 rollback segment(s) are active.
- 2016-12-29 12:37:52 3110 [Note] InnoDB: Waiting for purge to start
- 2016-12-29 12:37:52 3110 [ERROR] InnoDB: Failed to find tablespace for table '"player"."offline_shop_npc"' in the cache. Attempting to load the tablespace with space id 31.
- 2016-12-29 12:37:52 936e9a500 InnoDB: Operating system error number 2 in a file operation.
- InnoDB: The error means the system cannot find the path specified.
- 2016-12-29 12:37:52 3110 [ERROR] InnoDB: Could not find a valid tablespace file for 'player/offline_shop_npc'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
- 2016-12-29 12:37:52 3110 [Note] InnoDB: 5.6.34 started; log sequence number 2279496
- 2016-12-29 12:37:52 3110 [Note] Server hostname (bind-address): '*'; port: 3306
- 2016-12-29 12:37:52 3110 [Note] IPv6 is available.
- 2016-12-29 12:37:52 3110 [Note] - '::' resolves to '::';
- 2016-12-29 12:37:52 3110 [Note] Server socket created on IP: '::'.
- 2016-12-29 12:37:52 3110 [Note] Event Scheduler: Loaded 0 events
- 2016-12-29 12:37:52 3110 [Note] /usr/local/libexec/mysqld: ready for connections.
die dump zum erstellen sieht folgender maßen aus:
Code
- DROP TABLE IF EXISTS `offline_shop_npc`;
- CREATE TABLE `offline_shop_npc` (
- `owner_id` int(11) NOT NULL DEFAULT '0',
- `sign` varchar(32) DEFAULT NULL,
- `name` varchar(32) DEFAULT NULL,
- `time` int(11) DEFAULT NULL,
- `x` int(11) DEFAULT NULL,
- `y` int(11) DEFAULT NULL,
- `z` int(11) DEFAULT NULL,
- `mapIndex` int(11) DEFAULT NULL,
- `channel` int(2) DEFAULT NULL,
- PRIMARY KEY (`owner_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
das habe ich in folgendes geänder:
Code
- DROP TABLE IF EXISTS `offline_shop_npc`;
- CREATE TABLE `offline_shop_npc` (
- `owner_id` int(11) NOT NULL DEFAULT '0',
- `sign` varchar(32) DEFAULT NULL,
- `name` varchar(32) DEFAULT NULL,
- `time` int(11) DEFAULT NULL,
- `x` int(11) DEFAULT NULL,
- `y` int(11) DEFAULT NULL,
- `z` int(11) DEFAULT NULL,
- `mapIndex` int(11) DEFAULT NULL,
- `channel` int(2) DEFAULT NULL,
- PRIMARY KEY (`owner_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
das ich keine InnoDB haben will sonder eine MyISAM
Egal welche Querry ich ausführe es kommt bei deinen der Tabelspace Error.
Vielleicht weiß jemand weiter
EDIT: unter mysql 5.5 läuft es ohne Fehler, bei 5.6 kommt der folgende fehler
