MySQL Forums
Forum List  »  Newbie

MSSQL Migration Fails with Table Full
Posted by: Zach Leffle
Date: December 05, 2016 07:12AM

Hello,

We've been trying to migrate an MSSQL database unsuccessfully for about a week now, we've enabled InnoDB files per table, validated that we have plenty of available room on the disk (200 GB), we've also changed some other settings in hopes that we could get past the following error when importing just 1 of the 290 tables.

'DBO`.`Table_1AB`:Inserting Data: The table 'Table_1AB' is full.

I can see that the .IBD file for the table gets to 4 GB every time before we get the error above.

We are running MySQL 5.7.16 on a Windows 2016 Server build with a 200 GB data drive and 100 GB log drive. All of our migration attempts have been through MySQL Workbench 6.3.8.

I'm currently out of ideas as to what is causing this since the documentation states that .IDB files will auto extend when InnoDB Files per Table is enabled and that we have not reached any file system constraints either. Any guidance will be much appreciated.

Thank you for your time.

Options: ReplyQuote


Subject
Written By
Posted
MSSQL Migration Fails with Table Full
December 05, 2016 07:12AM


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.