Which tables or rows should I copy if I want to export the settings?

  • Resolved ofmarconi

    (@ofmarconi)


    6 months, 2 weeks ago

    Hello!

    I know that there is an import and export method, but I have a multisite and it is not very clear how to do this for the entire network.

    Well, if this isn’t possible through the panel, I decided to do it through MySQL, so I need to know which tables I need to copy/synchronize with the other subsites, is all the configuration we do stored in wp_options?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support qtwrk

    (@qtwrk)

    all the settings are in wp_options tables , with name starts with litespeed. (don’t miss the dot ) , the network will have multiple wp_options table, one per each

    Plugin Support litetim

    (@litetim)

    Hello
    I have 2 ideeas:
    Manual: from what I see in code the import functionality is to take each settings that are present in file and save it to database. Some values are JSON encoded(for the settings you want to change yourself in .data file exported). You can try this by deleting all settings except 1 and test if value is applied. Then use the import functionality from admin page.
    Automatic: if you use a VPS and have access to terminal you can use import from CLI: https://docs.litespeedtech.com/lscache/lscwp/cli/#import-options or https://docs.litespeedtech.com/lscache/lscwp/cli/#import-remote-options

    Thread Starter ofmarconi

    (@ofmarconi)

    Hi @litetim,

    Thank you very much for the detailed ideas on how I can manage the LiteSpeed Cache plugin settings on my WordPress multisite. After evaluating your suggestions, I agree that the automatic approach using the CLI seems to be the most efficient, especially considering that I have terminal access on my VPS. This approach will allow me to manage settings in a more controlled and automated way.

    I would also like to thank you for the links to the documentation, which will certainly facilitate the implementation process.

    thx so much

    Plugin Support litetim

    (@litetim)

    @ofmarconi you are welcome! ??

    If everything is ok please close the topic.

    Thread Starter ofmarconi

    (@ofmarconi)

    oops, I had forgotten.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Which tables or rows should I copy if I want to export the settings?’ is closed to new replies.