After transferring the magento store to new server and database you might find that the magento admin is not loading the CSS and JS files. Because of that, the design would look out of order and the categories pages would not display the products.

To fix this, you have to run the following SQL Queries:

SET FOREIGN_KEY_CHECKS = 0;
UPDATE `core_store` SET `store_id` = '0' WHERE `store_id` = 2 LIMIT 1 ;
UPDATE `core_website` SET `website_id` = '0' WHERE `website_id` = 2 LIMIT 1 ;
UPDATE `core_store_group` SET `group_id` = '0' WHERE `group_id` = 2 LIMIT 1 ;
SET FOREIGN_KEY_CHECKS = 1;