Upgrade and backup issues

My production version is currently 2.2.7.

I wanted to upgrade that to 2.3.1.

So, first problem is that I no longer can log into as admin in the Training Co. in 2.2.7. I tried to change the password as outlined elsewhere in this forum in PHPmyadmin, which did not seem to take.

I then did a backup in the 2.2.7 database from within Frontaccounting.

Then, 2.3.1 was installed in a new database and directory.

I tried to restore the 2.2.7 database into the 2.3.1 database, everything seemed to work (no error messages), but when I tried to see if there was any data in the 2.3.1 database, it was empty.

Any thoughts?