necesito crear nueve tablespaces dentro de MySQL. Se han de crear porque están migrando un proyecto de Oracle a MySQL y en Oracle existían estos tablespaces, y quieren mantener esta estructura. No hay posibilidad de reprogramar el código, o adaptarlo para no utilizar tablespaces.
Os mando pantallazos para que por favor me echéis un cable. Gracias por vuestra colaboración.
mysql> select @@storage_engine;
+------------------+
| @@storage_engine |
+------------------+
| InnoDB |
+------------------+
1 row in set (0.00 sec)
mysql> CREATE TABLESPACE tablespace_test ADD DATAFILE 'tablespace_test01' USE LOGFILE GROUP gropu_test ENGINE = INNODB;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show warnings;
+---------+------+------------------------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------------------------------------------------------+
| Warning | 1478 | Table storage engine 'InnoDB' does not support the create option 'TABLESPACE or LOGFILE GROUP' |
+---------+------+------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Server version: 5.5.16 MySQL Community Server (GPL)
Sigo un ejemplo que hay por Internet:
mysql> create tablespace testts add datafile 'myfirstfile'
-> engine = falcon;
Query OK, 0 rows affected, 2 warnings (0.00 sec)
mysql> show warnings;
+---------+------+------------------------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------------------------------------------------------+
| Warning | 1286 | Unknown storage engine 'falcon' |
| Warning | 1478 | Table storage engine 'InnoDB' does not support the create option 'TABLESPACE or LOGFILE GROUP' |
+---------+------+------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> create tablespace testts add datafile 'myfirstfile' engine = innodb;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> \W
Show warnings enabled.
mysql> create tablespace testts add datafile 'myfirstfile' engine = innodb;
Query OK, 0 rows affected, 1 warning (0.00 sec)
Warning (Code 1478): Table storage engine 'InnoDB' does not support the create option 'TABLESPACE or LOGFILE GROUP'
