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
598
June 20, 2019 02:55PM


Sorry, only registered users may post in this forum.

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.