0

I'm starting with a blank M2 data with no extensions installed. Using the data migration tool from ce 1.9.3.1 to ce 2.3.4 with the following command

php bin/magento migrate:settings --auto vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.1/config.xml

I receive error

[2020-04-13 22:14:00][ERROR]: Integrity check failed due to "core_config_data" document does not exist in the destination resource

In Mysql.php line 110:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'i2120969_db1.db_core_config_data' do
  esn't exist, query was: SELECT COUNT(*) FROM `db_core_config_data`

In Mysql.php line 91:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dataname_db1.db_core_config_data' doesn't exist

I have been working on this for hours and can't find anyone online who has gotten by this error. If anyone has any suggestions it would be appreciated.

2 Answers 2

0

When you looked at the tables in phpmyadmin the magento 2 tables, if you open the phpmyadmin and you see tables start name see for ex. mg_core_config_data

And chnage the your config.xml file :-

<dest_prefix /> to <dest_prefix>mg_</dest_prefix>

Any query let me know

Thanks.

7
  • The 2.3.4 data has a prefix of db_ indicated in the config.xml <dest_prefix>db_</dest_prefix>
    – user14396
    Apr 15, 2020 at 0:25
  • Please share your database screen shot Apr 15, 2020 at 2:48
  • Can you share me Magento 1 and Magento 2 database screen shots?? Apr 15, 2020 at 3:10
  • Thank you, here are the screen shots ibb.co/QkVtcZw
    – user14396
    Apr 15, 2020 at 14:08
  • Please post your config.xml file Apr 15, 2020 at 17:40
0

The config.xml was pointing to the wrong data. After pointing to the correct db everything migrated

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.