Magento 404 and/or cannot login to admin page after migrating site or restoring database

Magento Administrator Login won't work after moving site - IRRITATING!!!
Magento Administrator Login won't work after moving site - IRRITATING!!!

Magento dataabse thngs have to be ZEROS - yours are probably ONES

SET FOREIGN_KEY_CHECKS=0;
UPDATE `core_store` SET store_id = 0 WHERE code='admin';
UPDATE `core_store_group` SET group_id = 0 WHERE name='Default';
UPDATE `core_website` SET website_id = 0 WHERE code='admin';
UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;

ALSO delete var/cache - completely

ALSO: If you start getting the admin page after SUCCESSFUL login, DLETE COOKIES or open Incognito window!!! (You can tell by putting in bad password to get error message?)

Tags: