MySQL – Table space Error issue

Asked By 40 points N/A Posted on -
qa-featured

Hi,

I was working with MySQL server along with oracle database and was coding it a bit. After coding when I ran MySQL Server along with the oracle database to get attached, I got this error message of Table Space creation. I know how to code into MySQL files and oracle files and did it correctly, but can’t figure out why this error occurs.
 
As a solution, I tried re-coding the files and rolled back the table space name so that it may help me out but it really didn’t work. This is the command I changed after the error
 
Mysql> CREATE TABLESPACE ts2 ADD DATAFILE ‘datafile2.dat’ USE LOGFILE GROUP 1g1
 
INITIAL_SIZE 12M ENGINE NBD;
 
After this change, I restarted the server and the reconnected the database, but after a pause the error re-appeared. Could someone resolve this error for me?
 
Thanks. 
 
 
Tablespace Error
 
Tablespace create failed with error:
 
Tablespace: EXPADMIN
 
File: /usr/local/oracle/oradata/prodhq2/expadmin.dbf
 
Do you want to continue creating other tablespaces?
SHARE
Answered By 0 points N/A #121725

MySQL – Table space Error issue

qa-featured

Hi,

First try to recover your tables by loading it into a new instance. If this will not work then try to create work tables. To do this, start an instance of MYSQL and create a test database and issue the Create Table command, discard the table space, copy the pre-existing .ibd file and import this database into it.
 
Now check the error manually. After analyzing the error, clean up the working database and manually move the ibd file from the $datadir to a safe location and drop this table.
 
Then you need to increase the internal table id value by creating number of tables and then drop all tables and database. Now, dump the table using MySQL dump to import this to any MY SQL.
 
Hope this will work.

Login/Register to Answer

Related Questions