Title: SQL File of Forms structure
Last modified: April 24, 2021

---

# SQL File of Forms structure

 *  Resolved [wiwinetwork](https://wordpress.org/support/users/wiwinetwork/)
 * (@wiwinetwork)
 * [5 years ago](https://wordpress.org/support/topic/sql-file-of-forms-structure/)
 * Hey,
 * from a back-up file from end of November 2020 I can both find and change the 
   files for the forms used on the website. Sadly this is not possible anymore.
   
   I am looking for the files to replace certain current parts of the forms with
   parts that have been used a few months ago due to severe bugs in the current 
   version.
 * And if there is no solution so I can find the tables: How to restore the forms
   without losing the member data and everything else that happened on the website
   since the back-up?
 * Best Regards

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Contributor [Champ Camba](https://wordpress.org/support/users/champsupertramp/)
 * (@champsupertramp)
 * [5 years ago](https://wordpress.org/support/topic/sql-file-of-forms-structure/#post-14363859)
 * Hi [@wiwinetwork](https://wordpress.org/support/users/wiwinetwork/)
 * UM forms are saved in the wp_posts and wp_postmeta table with the custom post
   type name ‘um_forms’. You will have to match the user meta key with the field
   meta key in the form if you want to recreate the form manually.
 * e.g. When User A has a country saved in the user meta with a key `country`. In
   the form builder, you will have to recreate the form with the predefined country
   field that has the meta key `country` to match the saved user data `country`.
   You can delete the form and fields via UM Form Builder – it won’t delete the 
   user data.
 * Regards,
 *  Plugin Contributor [Champ Camba](https://wordpress.org/support/users/champsupertramp/)
 * (@champsupertramp)
 * [5 years ago](https://wordpress.org/support/topic/sql-file-of-forms-structure/#post-14378060)
 * Hi [@wiwinetwork](https://wordpress.org/support/users/wiwinetwork/)
 * ..Please feel free to re-open this thread by changing the Topic Status to ‘Not
   Resolved’ if any other questions come up and we’d be happy to help. 🙂
 * Regards,
 *  Thread Starter [wiwinetwork](https://wordpress.org/support/users/wiwinetwork/)
 * (@wiwinetwork)
 * [4 years, 12 months ago](https://wordpress.org/support/topic/sql-file-of-forms-structure/#post-14449746)
 * Thanks for the explanation [@champsupertramp](https://wordpress.org/support/users/champsupertramp/),
 * sadly there are no entries with the post type ‘um_forms’ in the data-base – neither
   in wp_posts nor in wp_postmeta. We are using UM-version 2.1.20 on a 5.7.33 mysql
   database-server.
    -  This reply was modified 4 years, 12 months ago by [wiwinetwork](https://wordpress.org/support/users/wiwinetwork/).
 *  Plugin Contributor [Champ Camba](https://wordpress.org/support/users/champsupertramp/)
 * (@champsupertramp)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/sql-file-of-forms-structure/#post-14614424)
 * Hi [@wiwinetwork](https://wordpress.org/support/users/wiwinetwork/)
 * Sorry for the late response. The post type should be `um_form` not `um_forms`.
 * Please feel free to re-open this thread by changing the topic status to “Not 
   Resolved” so that we can get back to you.
 * Regards,

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘SQL File of Forms structure’ is closed to new replies.

 * ![](https://ps.w.org/ultimate-member/assets/icon-256x256.png?rev=3160947)
 * [Ultimate Member – User Profile, Registration, Login, Member Directory, Content Restriction & Membership Plugin](https://wordpress.org/plugins/ultimate-member/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ultimate-member/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ultimate-member/)
 * [Active Topics](https://wordpress.org/support/plugin/ultimate-member/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ultimate-member/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ultimate-member/reviews/)

## Tags

 * [backups](https://wordpress.org/support/topic-tag/backups/)
 * [forms](https://wordpress.org/support/topic-tag/forms/)
 * [formula](https://wordpress.org/support/topic-tag/formula/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 4 replies
 * 2 participants
 * Last reply from: [Champ Camba](https://wordpress.org/support/users/champsupertramp/)
 * Last activity: [4 years, 10 months ago](https://wordpress.org/support/topic/sql-file-of-forms-structure/#post-14614424)
 * Status: resolved