Fixed - Magento Admin showing 404 error whem transfering to another server

When I tranered the Magento site from my  server to client server ( Hostgator )  then I got the 404 Error when accessing the admin panel. 

Run the below SQL Query and the problem will be fixed.


Solution:

- Open PhpMyAdmin
- Go to your database
- Click SQL
- Run the following SQL Query:

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;

That’s all. Your error is solved now.