Change the base url from database in Magento

Change the base url from database in Magento

If you have by mistakenly changed your base url from your Magento configuration page, then your store not going to come anymore and its dead. So, in order to fix it, you need to change the base url back to what it was and since your admin panel is gone, so your last option is doing it via database.

You have to go to your Database via phpmyadmin and enter in the core_config_data table.
Under this table you have to find under the path column web/unsecure/base_url and edit the value column with the correct url {{base url}} or with the Url of your magento (ex. http://www.yoursite.com).

DOWNLOAD SOLUTION HERE