Trying to migrate data from Drupal 7 to new install on Drupal 9
This sounds a bit dicey, but fortunately I think there's a simpler solution.
My answer on migrating CiviCRM to WordPress is generic for moving CiviCRM to ANY new CMS - even the same CMS on a different site.
I would fix the civicrm_menu issue separately.  You should be able to restore a copy from a fresh install, then disable/re-enable any extension, which will re-add any &quot;managed entity&quot; entries - in practical terms, those added by extensions.