i was able to successfully migrate from 1.9 to magento 2 using data migration tool, from github. the tools migrates everything except for cms pages, and cms blocks. I dump the pages and blocks tables from old db to new db, but i am getting an error related to duplicate primary key. i am not good with sql queries - what is the best way to dump this data?


try to run

TRUNCATE TABLE  table_name;

on your cms tables.. and the run the import again

  • TRUNCATE would delete the table completely, no? it looks like my old db tables have prefix. – roger Feb 22 '16 at 22:16
  • No truncate will clear the table, the table structure will stay – Eugen Bogdanovich Feb 23 '16 at 11:17
  • i got the error - primary key cannot be TRUNCATE – roger Feb 24 '16 at 1:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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