MySQL Forums
Forum List  »  Data Recovery

alter table db.table import tablespace .cfg file format
Posted by: Declan OReilly
Date: June 20, 2019 02:55PM

Hi

I would like to import data to a table in mysql using the 'alter table db.table import tablespace' command. This works for most tables, but if the table contains a decimal, I get an error 'Error Code: 1808. Schema mismatch (Column columnName precise type mismatch.)'

I believe that my schema is correct, so I was wondering is it possible to parse/read the tableName.cfg file so I can check, what the .cfg believes the format to be.

mysql version: 8.0.15

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
alter table db.table import tablespace .cfg file format
960
June 20, 2019 02:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.