Magento 2 makes it hard for me to handle configuration settings for system_config area.

Since I have not received any answers there yet, I need to try something else to solve the issue.

(Assuming I don't get any answers there): As explained in the other question, I have around 1500 settings (ALOT from a 3rd party theme) settings that are in the config.php file, and not importable into database when using app:config:dump.

I want to find the unique entries for specific sections and import them into the new database so that I can have values for the theme, EDITABLE in the backend! Keep in mind the users that will use the backend would not know how to edit the file config.php correctly.

I have now exported the core_config_data entries that exist in a source database and a new M2.3.5 installation database.

So, entries around 1700 in the one, and around 50 in the other.

I am using C# to parse the SQL export files, but I need assistance with a non-greedy regex solution.

Splitting just with C# proves hard, because I can't really use the , character, see example entries below: (the state_required entry has multiple states).

The idea is to extract each row's path entry (they are already split into individual row entries) and compare between the database to see if they exist or not (as mentioned I will try to import mostly the custom theme entries).

('default',0,'web/seo/use_rewrites','1','2019-12-10 10:47:26.0')
('default',0,'general/region/display_all','1','2019-12-10 10:47:26.0')('default',0,'general/region/state_required','AU,CA,CH,CN,CO,EE,ES,LT,LV,MX,PL,RO,US','2020-09-30 20:41:40.0')
('default',0,'catalog/category/root_id',NULL,'2019-12-10 10:47:26.0')

Currently : I have several attempts to extracting the path, but most attempts are 'greedy' and select more text than needed.

The most accurate one:

Issue is not all my entries are ~ 'default',0


A more generic attempt that captures seperate entities: - needs improvement.


How can I select the above SQL entries to get the path entry reliably?

I want the following as a result set extracting it from the SQL so that I can compare them between the MySQL databases:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.