Hi Suresh,
Good job in making backups! Let's see if we can help sort this out.
First, can you check your webserver error logs to get more information on the nature of this 500 error? If you have followed our recommended installation instructions and are using Nginx as your webserver, you can check the logs with:
- sudo tail -f /var/log/nginx/error.log
Let us know what you find there.
Typically, I would recommend that you treat loading a database backup the same way we recommend loading your data during an upgrade:
- Make sure you still have your backup stored outside of AtoM
- Drop and recreate the database: mysql -u root -p -e 'drop database new_database; create database
new_database character set utf8 collate utf8_unicode_ci;' - Load the backup
- Run the upgrade task: php symfony tools:upgrade-sql
- Restart services, such as PHP-FPM
- Using PHP7.0: sudo systemctl restart php7.0
- Using PHP7.2: sudo systemctl restart php7.2
- If you have memcached installed, let's restart it as well: sudo systemctl restart memcached
- Let's clear the atom-workers fail count, and then restart it:
- sudo systemctl reset-failed atom-worker
- sudo systemctl restart atom-worker
- You can check that it started properly with: sudo systemctl status atom-worker (use CTRL+C to exit after)
- Clear the application cache: php symfony cc
- Re-populate the search index: php symfony search:populate
Hopefully that should help resolve everything! Let us know how it goes, and what you find in the webserver error logs.
Cheers,