How to download all database from contact form 7?

Posted in


I’m using Affiliate Pro with Contact Form 7.

1. How do I download all database refered from my affiliate via the contact form 7? I should be able to download them right for my reference.

2. Why is it I’m not getting all the information from the contact form 7 refered by my affiliate? It’s hard for me to track which lead is whose.

3. Plus I’m also getting this:

I’ve enabled the notification setting.

Which I have the latest plugin installed and still getting the message.

By the way where can I donwload enable automatic updates for your plugins by itthinx?

Thank you.

9 Responses to How to download all database from contact form 7?

  1. Hazli June 3, 2014 at 6:20 pm #

    Ok found it!

    Thank you Kento.

    But is there a way for me to download it to excel sheet?

    • kento June 4, 2014 at 10:28 am #

      Currently not, but we’ll be adding new export features which will allow to do so.

  2. Hazli May 28, 2014 at 10:43 am #

    Hi Kento,

    Yes I need the database, all the information refered by my affiliate via the contact form.

    Because right now I’m not getting all the notification, and some conflict with which lead is whose by my affiliate.

    If I can have all the information, who refered who along with Name, Phone Numbers and so on, then it’ll be easy for me to track.

    Because I’m running it for local MLM company.

    And I can’t handle it without the master list.

    Thank you.

    • kento June 2, 2014 at 9:11 am #

      Ok thanks, but you already have that information available under Affiliates > Referrals. Simply enable these filters on top of the page: Expand details, Expand descriptions, Expand data. And you can use the search field (also check the Descriptions option for the field) to track down individual referrals based on form data and lead details as that is recorded along with the referrals.

  3. Hazli May 23, 2014 at 3:22 pm #

    Hi Kento,

    Sorry, I’m no technical guy. Seriously I have no clue what is MySQL or SSH.

    Do you have and documented walkthrough such as video that I can follow along?

    Thank you.

    • kento May 27, 2014 at 6:58 pm #

      Hi Hazli,

      Do you have phpMyAdmin available on your hosting account? Also, can you please explain what you want to do with the data you obtain from the database? Based on that, we can suggest a more appropriate solution taking into account the level of expertise you have with the facilities available.

  4. Hazli May 23, 2014 at 10:57 am #

    Hi Kento,

    I don’t understand. How do I do this:

    SELECT * FROM wp_aff_referrals INTO OUTFILE ‘/tmp/referrals.txt’;

    What I mean by contact form 7 database is all the information key in by the lead refered by my affiliate such as name, phone numbers, address etc?

    • kento May 23, 2014 at 12:27 pm #

      That’s a query you can run on the MySQL database directly, for example using phpMyAdmin. You would access that through your server’s admin panel provided by your hosting service. Or you can log in to your server via SSH and run that query through the MySQL console directly.

  5. kento May 23, 2014 at 10:50 am #

    Hi Hazli,

    #1 You can export referral data directly from the database using

    SELECT * FROM wp_aff_referrals INTO OUTFILE '/tmp/referrals.txt';

    We are also working on an export feature for referral data on the administrative back end.

    #2 Under Affiliates > Referrals you should enable Expand details and Expand data to see all data recorded along with the referrals.

    #3 The error message shown isn’t related to the plugins.

    #4 You should install the itthinx updater plugin using your service key. See Service Key for details and as shown in the screenshot from #3, you can click the link in the first message to install the plugin.

We use cookies to optimize your experience on our site and assume you're OK with that if you stay.
OK, hide this message.

Affiliates · Contact · Jobs · Terms & Conditions · Privacy Policy · Documentation · Downloads · Useful Plugins · My Account