I built a WP site on one server and am now trying to move it over to another server. I created a backup of the MySQL database and all the files. I uploaded all the files via FTP no problem. I then created the database on the new server, imported the backup (successfully), and edited my config file to match. But all I get is a 500 server error. So I created another (empty)database, edited the config to match, and it works fine. But when I try to switch back to the first database it fails again.
What am I doing wrong? What is it about full database that might not be working? Are there are setting, version numbers, or anything like that that might need editing?