In magento by deafult the configuration information for site management is kept in database table. The name of the table is ‘core_config_data’. If we analyze the tables we get that magento keeps its data in the following table. So if we want to develop our application in our localhost and then deploy the site in the hosting server we might need to change the path accordingly to run the site from that server.
Here we see that magento keeps its base url as below
(2, ‘websites’, 2, ‘web/unsecure/base_url’, ‘http://192.167.3.7/magento/’)
So here we can change that url easily as we need to. This way we can configure multiple URL for multiple site also. In my case this tricks worked fine with Magento 1.3.1
CREATE TABLE `core_config_data` (
`config_id` int(10) unsigned NOT NULL auto_increment,
`scope` enum(‘default’,'websites’,’stores’,'config’) NOT NULL default ‘default’,
`scope_id` int(11) NOT NULL default ‘0′,
`path` varchar(255) NOT NULL default ‘general’,
`value` text NOT NULL,
PRIMARY KEY (`config_id`),
UNIQUE KEY `config_scope` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;
–
– Dumping data for table `core_config_data`
–
INSERT INTO `core_config_data` (`config_id`, `scope`, `scope_id`, `path`, `value`) VALUES
(1, ‘default’, 0, ‘catalog/category/root_id’, ‘2′),
(2, ‘websites’, 2, ‘web/unsecure/base_url’, ‘http://192.167.3.7/magento/’),
(3, ‘websites’, 2, ‘web/unsecure/base_link_url’, ‘{{unsecure_base_url}}ucc/’),
(4, ‘websites’, 2, ‘web/secure/base_url’, ‘https://192.167.3.7/magento/’),
(5, ‘websites’, 2, ‘web/secure/base_link_url’, ‘{{secure_base_url}}ucc/’),
(6, ‘websites’, 2, ‘web/default/front’, ‘cms’),
(7, ‘websites’, 2, ‘web/default/cms_home_page’, ‘home’),
(8, ‘websites’, 3, ‘web/unsecure/base_url’, ‘http://192.167.3.7/magento/’),
(9, ‘websites’, 3, ‘web/unsecure/base_link_url’, ‘{{unsecure_base_url}}technocare/’),
(10, ‘websites’, 3, ‘web/secure/base_url’, ‘https://192.167.3.7/magento/’),
(11, ‘websites’, 3, ‘web/secure/base_link_url’, ‘{{secure_base_url}}technocare/’),
