I am currently trying to migrate the Drupal Site from FreeBSD 12 to Ubuntu 18.04. All the configurations are copied and moved to Ubuntu 18.04. Everything seems fine and I was able to create the Drupal Site with Ubuntu 18.04, but whenever I clear the cache on the new site, it seems like the page settings are gone and the content goes all over the place. Also, the newest content gets erased as well. I usually use mysqldump command line to dump the mysql database and restore the backup with the mysql command line. I have also tried downloading phpmyadmin to dump and restore the mysql database, but the issue is still present. This is a critical issue on the site, because installing a new module automatically deletes cache.
Drupal Version: 7.59
I am guessing when the mysql database is dumped, the newest content and page settings goes into cache..? I am not really familiar on how mysql saves the database. Any help would be a great help for me to proceed with the migration. Thank you!