Export appears limited to preview rows
Hi - I'm new to MySQL for Excel so forgive me if I'm making a naive mistake somewhere. I'm using MySQL for Excel 1.3.3 and Workbench 6.2.
I'm trying to use it to export 35000 rows of data in my spreadsheet to MySQL. I then use MySQL Workbench to dump the .sql file of the table for my website administrator to load into our website database.
The exports appear to transact successfully - but when I check them in workbench I appear to find only either 99 or 999 rows of data in the tables. When, in MySQL for Excel, I had the number of rows for preview and calculate datatype set to 100 - I appeared to get 99 rows exported, when I set it to the maximum of 1000 I got 999 rows exported.
What am I doing wrong please ?
Kerry
Subject
Views
Written By
Posted
Export appears limited to preview rows
3762
November 20, 2014 07:22AM
1603
November 20, 2014 10:38AM
1732
November 20, 2014 12:40PM
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.