Home › Forums › ACF PRO › Options Page – Export Content › Reply To: Options Page – Export Content
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
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
ACF wouldn’t be so widely used in WordPress if it didn’t have some pretty amazing capabilities. In this article, we look at a few of the features we’ll discuss during “7 things you didn’t know you could do with ACF” at #WPEDecode later this month. https://t.co/5lnsTxp81j pic.twitter.com/Yf0ThPG1QG— Advanced Custom Fields (@wp_acf) March 16, 2023
© 2023 Advanced Custom Fields.