I decided to go the hard route with this…
From the source database that contains the options page values that you want:
SELECT *
INTO OUTFILE '/tmp/wp_options.csv'
FIELDS TERMINATED BY ';'
OPTIONALLY ENCLOSED BY '"'
FROM wp_options WHERE option_name LIKE '%options_form_steps%';
Your prefix will be different, you’ll need to modify the LIKE above.
You will then want to transfer your CSV file to the server that you want to import them on. You can then import that file:
mysqlimport -hHOST_HERE -pPASSWORD_HERE -u USERNAME_HERE --local --fields-terminated-by=";" --fields-enclosed-by='"' --columns='option_name,option_value,autoload' DBNAME_HERE /var/www/database/wp_options.csv
Enjoy responsibly.
