Title: Export to Database
Last modified: November 17, 2022

---

# Export to Database

 *  Resolved [bbrdes](https://wordpress.org/support/users/bbrdes/)
 * (@bbrdes)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/export-to-database/)
 * Hey there,
 * I was just curious if your plugin has SQL connection capabilities.
 * Thank you for your time.

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

 *  Plugin Support [Jasmine](https://wordpress.org/support/users/hyenokian/)
 * (@hyenokian)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/export-to-database/#post-16211219)
 * Dear [@bbrdes](https://wordpress.org/support/users/bbrdes/),
 * Thank you for the topic.
 * At the moment, unfortunately, the plugin doesn’t have the possibility to export
   its tables.
 * By the way, thank you very much for your suggestion.
    All suggestions are welcomed
   as they are mutually beneficial for all of us.
 * We will let you know in case there is an update in this regard.
 * By the way, currently, the only possible solution to achieve this is by going
   to your **cPanel > particular Database** and exporting the tables from there.
 * Thank you.
 *  [eicken71](https://wordpress.org/support/users/eicken71/)
 * (@eicken71)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/export-to-database/#post-16318182)
 * No problem if individual submission data can be retrieved with phpMyAdmin from
   the WordPress database. But how exactly is it done? Is it enough to export the`
   ayssurvey_submissions` table? Or what else would need to be done? Could you give
   an example for the SQL query that needs to be run?
 *  Plugin Support [Jasmine](https://wordpress.org/support/users/hyenokian/)
 * (@hyenokian)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/export-to-database/#post-16320114)
 * Dear [@eicken71](https://wordpress.org/support/users/eicken71/),
 * Thank you for your response.
 * I am not sure I understand your request correctly.
   As far as I understand, you
   want to select the whole data of both your mentioned table and the ayssurvey_submissions_questions
   table. This is the reason you want the SQL.
 * Here is an **example** of how you can take one submission from that tables:
   Please
   note, that the WordPress_prefix can be subject to change, by default it is written
   by **wp_**.
 * You need to insert your desired Submission ID instead of the YOUR_SUBMISSION_ID.
   
   You can find it in each submission list table on the Dashboard (**Submissions
   tab**).
 * See the screenshot: [https://ibb.co/Yy4QgCk](https://ibb.co/Yy4QgCk)
 * SELECT * FROM ՝wp_ayssurvey_submissions՝ WHERE `id`=YOUR_SUBMISSION_ID;
 * SELECT * FROM `wp_ayssurvey_submissions_questions` WHERE `submission_id`=YOUR_SUBMISSION_ID
 * Thank you.

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

The topic ‘Export to Database’ is closed to new replies.

 * ![](https://ps.w.org/survey-maker/assets/icon-256x256.png?rev=2444244)
 * [Survey Maker by AYS](https://wordpress.org/plugins/survey-maker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/survey-maker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/survey-maker/)
 * [Active Topics](https://wordpress.org/support/plugin/survey-maker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/survey-maker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/survey-maker/reviews/)

## Tags

 * [connection](https://wordpress.org/support/topic-tag/connection/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 3 replies
 * 3 participants
 * Last reply from: [Jasmine](https://wordpress.org/support/users/hyenokian/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/export-to-database/#post-16320114)
 * Status: resolved