1, Via mysql command line
Select the database
Mysql>> use database;
Now run the following command to list the current base url
Mysql>> select * from core_config_data where path like ‘%base%url%’;
To change the base URLs, execute the following commands from mysql prompt
update core_config_data set value = ‘http://domainname/’ where path = ‘web/unsecure/base_url’;
update core_config_data set value = ‘http://domainname/’ where path = ‘web/secure/base_url’;
2, Via phpmyadmin
Take PhpMyAdmin and select the required database. Now you will see a list of all the tables in the database in alphabetical order. Search for the table.
Expand the viewing area of phpMyAdmin. At the top and bottom in the main panel, locate the grey box and change the Number of rows to a larger number, such as 100.
Locate the rows web/unsecure/base_url and web/secure/base_url and click Edit next to the corresponding lines. Change the base URL to the intended string, and click OK.
Flush the Magento cache, and the site should load with the set base URLs properly now.
3, Magento Admin Panel.
From majento admin panel click System > Configuration.
From the menu on the left, under the General list>> web
Open the Unsecure and Secure dropdowns, locate the base URL line, and replace this with the new URL.
Clear the Magento cache and your browser’s cache. The site should now load properly.