cannot update database

I installed on localhost my upgraded store w/o products. Then I went into myphpadmin and imported my database. My store says I need to upgrade the database (expected) so I run the update. But I get stumped at entering my admin name and password. It says it is not correct! Both the local install and the live store database I imported are the same admin and password. Any idea why I cannot log in?

What error message you are getting
Also did you overwrite the login.php in the template directory?

I get this error: ATTENTION: Problems Found

* Admin Password required to proceed with upgrade more info...

Now it is like my passwords won't work. Obviously I won't take this to a live site until I can get the database to upgrade. Also, I cannot log into the admin area after the database is merged.

Login to phpmyadmin and run the update sql
and then try this
https://www.zen-cart.com/tutorials/index.php?article=2

Thank you. That worked. Any idea why it would have 'lost' my admin password?

Not really sure but sometimes it does happens during the upgrade!

superprg:

Not really sure but sometimes it does happens during the upgrade!

It only "happens during the upgrade" if you somehow break the data during an export/import or if you are pointing to the wrong database in your configure.php files.
The upgrade itself will not "lose" your admin details.

ah, that makes sense. In my myphpadmin in the import section has the 'break up' checked by default.

---->
Partial import
Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions. <----