Description:
hi,
I am currently updating a Windows application to use mySQL as the backend database and the Access database to be the front end. Hence, I am converting an Access database to mySQL database using the migration assisstant on MYSQL Workbench.
I have arrived at the Bulk Data Transfer step (last step) without errors so far but now now I get an error saying:
"ERROR: Determine number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 3221225477
Failed"
Here is the Full message log:
Starting...
Prepare information for data copy...
Prepare information for data copy done
Determine number of rows to copy....
Counting number of rows in tables...
wbcopytables.exe --count-only --passwords-from-stdin --odbc-source="DSN=dbDEMCON_accdb" --source-rdbms-type=MsAccess --source-timeout= --target-timeout=None --table-file=C:\Users\kc\AppData\Local\Temp\tmpplffyjzj
--table "tblAdmins"
10:11:14 [INF][ copytable]: --table "tblReservedTable"
10:11:14 [INF][ copytable]: --table "tblShops"
10:11:14 [INF][ copytable]: --table "tblPrototypes"
10:11:14 [INF][ copytable]: --table "tblApplicationValues"
10:11:14 [INF][ copytable]: --table "tblKeys"
10:11:14 [INF][ copytable]: --table "tblSalesUsers"
10:11:14 [INF][ copytable]: --table "tblPorts"
10:11:14 [INF][ copytable]: --table "tblConfigurations"
10:11:14 [INF][ copytable]: --table "tblPrototypesValues"
10:11:14 [INF][ copytable]: --table "tblPermissions"
10:11:14 [INF][ copytable]: --table "tblDESystems"
10:11:14 [INF][ copytable]: Opening ODBC connection to [MsAccess] 'DSN=dbDEMCON_accdb;PWD=XXX'
10:11:14 [INF][ copytable]: ODBC connection to 'DSN=dbDEMCON_accdb;PWD=' opened
Loading table information from file C:\Users\kc\AppData\Local\Temp\tmpplffyjzj
ROW_COUNT::"tblAdmins": 0
ROW_COUNT::"tblReservedTable": 0
ROW_COUNT::"tblShops": 0
ROW_COUNT::"tblPrototypes": 0
ROW_COUNT::"tblApplicationValues": 0
ROW_COUNT::"tblKeys": 0
ROW_COUNT::"tblSalesUsers": 0
ROW_COUNT::"tblPorts": 0
ROW_COUNT::"tblConfigurations": 0
ROW_COUNT::"tblPrototypesValues": 0
ROW_COUNT::"tblPermissions": 0
ROW_COUNT::"tblDESystems": 0
FINISHED
ERROR: Determine number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 3221225477
Failed
How to repeat:
To repeat: go through the whole migration process with all the default settings, just press next at each stage.
I will provide an empty database for your perusal.
Suggested fix:
I have tried:
Adding some random data to the database.
Running Workbech as Administrator.
