Blog Settings import/export in WordPress Network environment

I can’t use PHPMyAdmin to export/import my blogs from one server to an other because I’m using WordPress Network.

Export/import works pretty well for Posts, custom posts types and their media, but not for the Blog settings themselves

How could I export my blog settings?

Some examples:

• sizes for Thumbnails, medium, large images
• Pictures cropping
• Date format
• show excerpts
• how many articles per pages
• …

my main goal being to apply all my beta website settings to the main website when fully tested and approved.

Export the options table that is specific to the multisite blog in question (just the option names and values), import them into the new options table on the new site.

This will work for every option that doesn’t use a prefixed option name, which is only user-specific stuff like capabilities and roles.