We are attempting to move off an old machine and onto a new but restoration of CiviCRM constantly fails with the error:
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred. DB Error: no such field
Here are the details
Old Machine: Drupal: 7.78 CiviCRM: 5.19 MySQL 5.5 PHP: 7.2
New Machine Drupal 7.89 CiviCRM: 5.47.1 MySQL: 8 PHP: 7.4
Moving Drupal was a breeze. No major issues. But Civi seems to require more intervention or skill that I do not yet possess.
I am dumping the old data using (where the Civi database is called civicrm)
mysqldump -u root -p --ignore-table=civicrm.civicrm_domain --ignore-table=civicrm.civicrm_acl_cache --ignore-table=civicrm.civicrm_acl_contact_cache --ignore-table=civicrm.civicrm_group_contact_cache civicrm > civi-sql-dump.sql
And ingesting the data using mysql -u root -p civicrm < civi-sql-dump.sql
But this fails to work. I've followed the instructions at https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/ but after a few tries, no success.
Is it possible to move between the two machine noted above? Would it just be faster to export data and re-import it and just re-setup Civi? I've check the log file /var/www/drupal/sites/default/files/civicrm/ConfigAndLog and it's a huge mess.
What are my options here? Thanks in advance for any tips or advice.