Skip to content

Magento 2.4.4: which is the table in Magento DB to update the URLs

We have a staging site which starts with magento2. I did recently dump the Magento DB from the live site into that of dev site because of which all links on the staging site redirect to the live site. I used to run the following SQL in the past to update the URLs in the dev Magento DB, but they don’t seem to work this time. Could you please tell me if they are still valid or what needs to be changed?

UPDATE `core_config_data` SET `value` = 'https://magento2.perfectmakeupmirrors.com/' WHERE `core_config_data`.`config_id` = 2;
UPDATE `core_config_data` SET `value` = 'https://magento2.perfectmakeupmirrors.com/' WHERE `core_config_data`.`config_id` = 3;