How to backup ACF option fields with SQL

  1. To get the values SELECT * FROM wp_options WHERE option_name LIKE 'options_%'"
  2. Export  as SQL
  3. Remove the ID column from the INSERT statements
  4. Then remove the old values by running DELETE FROM wp_options WHERE option_name LIKE 'options_%'"
  5. And finally run the exported insert statement! Voila!