D6-D8 migration: How did we find missing migrations?

We were working on D6 to D8 migration projects where we were migrating the revised database of D6 site to D8 site every other month.

We started with full migration initially and then with partial migration subsequently. This was working perfectly fine. We were using drush commands to do the migration.

But recently when we got the latest D6 database, we were no longer seeing term node migration entities (d6_term_node__1, d6_term_node__2 etc.) with drush migrate-status command in D8. Although migration worked fine for all other items but as we were not seeing term node relationship entities (d6_term_node__1) so latest migrated content doesn't had terms associated with it.

We tried switching to old D6 database but that didn't help. We tried using --configure-only option with drush command to regenerate the migrations but even that didn't help,

drush migrate-upgrade --configure-only --legacy-db-url=mysql://drupaluser:@127.0.0.1:33067/d6 --legacy-root=http://d6.local:8083

We also checked "config" table but those migrations were not present there,

SELECT * FROM `config` WHERE `name` LIKE '%d6_term_node%';

We were almost stuck and not sure what to do.

As were using revision control and code management system (GIT) so after the first migrate-upgrade, we exported the configuration (Configuration Synchronization - full export) into git repository. At this point, d6_term_node_* migrations were present.

So, to recover the missing migrations, we imported those files (migrate.migration.d6_term_node__1.yml, migrate.migration.d6_term_node__2.yml etc.) one by one from Configuration synchronization->Import->Single item (/admin/config/development/configuration/single/import),


After the import above, we could see those missing migration using "drush ms" command and imported those missing migrations successfully.
drush migrate-import d6_term_node__1
drush migrate-import d6_term_node__2

You can find more information on how to execute Drupal upgrade using Drush commands here - https://www.drupal.org/node/2350651.

Comments

Post a Comment

Popular posts from this blog

Simple Meditation

Set small goals, such as meditating for two minutes every morning. When that feels OK, up the time to 5, 10 or 20 minutes. 1) Find a comfortable seat - where you can sit up tall, either crosslegged on the floor or in a chair. Close your eyes or soften the gaze so you are not focusing on anything in particular. Place the hands with the palms down on the tops of the thighs. 2) Take a moment to notice the sensation of sitting - become aware of the ground or chair beneath you, and the parts of your body in contact with them. Now bring your focus to your hands, noticing the weight of them on the thighs, and the feel of the fabric of your clothes.  3) Now begin to notice how your breath feels in your body as you inhale and exhale. Make no effort to change the breath, simply let your natural breath flow in and out. 4) Aim to stay focussed on these sensations of the breath, but when you notice the mind wandering, acknowledge the thought, then come back to the breath again.  5) When yo...
Read more

Custom MySQL Database to Drupal 8 Migration

Image
There are thousands of websites which are using MySQL as database. If we need to migrate data from Websites, which are using MySQL database, to Drupal 8 then we can use this blog post as starting point. We have a sample MySQL Database 'mysql_custom_db' which contains two tables, users and pages. The data in 'users' table looks like below,   The data in 'pages' table looks like below, As all the fields in 'users' table, from source database, will map to User entity in Drupal 8 site so we don't need make any changes there. But as we are migrating 'pages' table data to 'Basic Page' content type in Drupal 8 site, so we need to create required fields in 'Basic Page' content type. We have created the fields in 'Basic Page' content type and it looks like below, In our migration, field mapping between source site (pages) and destination site (Basic Page' content type) is like below, city...
Read more