I am transfering a magento website and I have lost nginx settings. But I have full access in the database.
In my case I want to find out upon each store url what values must have the MAGE_RUN_CODE
and MAGE_RUN_TYPE
fastcgi params.
Therefore I have tried the following query directly from db:
select
store.code,store_website.code,store_group.code,
urls.*
from
store
join store_website on store.website_id = store_website.website_id
join store_group on store_group.website_id = store_website.website_id
left join
(
select
scope_id,path,value
from
core_config_data
where `path` in (
'web/unsecure/base_link_url'
'web/secure/base_link_url'
'web/unsecure/base_link_url'
'web/secure/base_link_url'
'web/unsecure/base_link_url'
'web/secure/base_link_url'
'web/unsecure/base_link_url'
'web/secure/base_link_url'
'web/unsecure/base_link_url'
'web/secure/base_link_url'
)
) as urls on urls.scope_id = store.store_id;
But the returned columns scope_id, path, value are all null. Therefore how I can map scope_id with nessesary codes from database.
Keep in mind that I have no access to the admin panel either therefore my only option is direct database selections.