Befor I forget, I use Magento I backuped my live Magento shop. Then I copied the backup to my test shop an loaded the backup. Now I cant reach the frontend or the backend. I'm always beeing redirected to the live Shop. I believe its because of the address set up in the shop. Where are they beeing saved?


1 Answer 1


you need to change in core_config_data table.


How to change base_url settings with mysql from the command line:

find your configuration:

select * from core_config_data where path = 'web/unsecure/base_url';
select * from core_config_data where path = 'web/secure/base_url';

edit your configuration:

update core_config_data set value = '/new.domain.com/' where config_id = ID;

with ID from above.

  • Thank fschmengler for the link. I changed everything, but still cant get on the front or backend. I checked if my browser is the problem, but any browser is going strait on the active shop. Backend login starts correct, but after login, i'm on the active shop. Not loged in of course.
    – DBR
    Commented Jan 28, 2016 at 20:19
  • OK, I just worked a little further. I got the shop so far, that I remain on the proper Domain. But he doubles the domainname. Like www.imdump.xyz/imdump.xyz/
    – DBR
    Commented Jan 28, 2016 at 20:34
  • Me .... again ;) Followed the instructions from here [stackoverflow.com/questions/9240518/… Now the shop is working finaly again. Thanks for the help!!!!
    – DBR
    Commented Jan 28, 2016 at 20:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.