The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

How can I find out the names of database tables a plugin is using? (23 posts)

  1. Sjors01
    Posted 5 years ago #

    Question is in the title. I'm using this plugin from Yann: http://wordpress.org/extend/plugins/yd-wpmu-sitewide-options/

    I can't find database tables from some of my plugins. How can I find these tables? Is there information stored in the plugin, so I can find these tables? Thanks in advance.

  2. If the plugin doesn't create new tables, you have to read the code (in the plugin) to see which tables the plugin is accessing.

  3. Sjors01
    Posted 5 years ago #

    Thanks for the tip Andrea, but can you show an example of how this would look in the .php file? I don't have any php knowledge whatsoever.

  4. See this statement in the plugin you've mentioned?

    $optionslist = $wpdb->get_results( "SELECT * FROM $wpdb->options WHERE NOT option_name LIKE '\\_%' ORDER BY option_name" );

    That pulls down a list :) So you're going to be looking for SQL statements.

    Pull up some PHP/SQL tutorials and settle in for the long haul. http://www.freewebmasterhelp.com/tutorials/phpmysql

  5. Sjors01
    Posted 5 years ago #

    Thanks for the course ipstenu!
    But there's nothing wrong with the plugin, it works fine. Sorry for the misunderstanding. I did find the code you mentioned, in the plugin itself.

    The plugin gives you a list of options (the settings of your plugins) which you can replicate over all your multi site blogs, but I can't find a few plugins options. Because the names are different. (the options don't always show the exact name of the plugin)

    If you still don't know what I mean you should install it and check it out, it's a very useful plugin.

    I would like to replicate these plugin options as well, so I need to know the names of the settings (database tables?)

    How can I find this out?

  6. I would like to replicate these plugin options as well, so I need to know the names of the settings (database tables?)

    How can I find this out?

    then look in the code of those particular plugin's files. they will all be different.

    There's a paid plugin that does all this for ya though.

  7. Sjors01
    Posted 5 years ago #

    Okay but can you give me an indication on how I could recognize this code? What's the name of this paid plugin? Thanks

  8. http://wpebooks.com/replicator/ I think.

    And as for how you recognize the code... That's why I showed you an example :) Look for SQL statements.

  9. Sjors01
    Posted 5 years ago #

    Okay, but that code appears in all plugins? I found it in the yd-wpmu-sitewide options plugin, but not in the plugin I wanted the know the database name for.

    Thanks for the link, will contact Andrea about it.:)

  10. The keyword in my sentence was "example" - Every plugin is different. You'll have to use your brain and read them on your own.

    And I know that plugin works. Never used it, but I've never needed to.

  11. Sjors01
    Posted 5 years ago #

    Andrea, I can't pm you on these forums. And I can't use the contact form on your website, so I'm going to ask my questions here:

    Will you have too identify database tables with your plugin? Can it replicate ALL plugin settings, without any problems? Does it automatically activate widgets? Can you save the plugin settings, to implement it to another wpms install?

    If this plugin fits my needs I will definitely buy it, and I might join your affiliate program for it.:)

  12. Why can't you use the contact form? If it's busted I need to fix it. :) I'd rather answer questions there or on twitter.

    But: no, yes, yes and no.

  13. Sjors01
    Posted 5 years ago #

    Please fix your contact form then, or I'll use twitter but I never used it for personal use before, lol.

  14. Sjors01
    Posted 5 years ago #

    I tweeted you!

  15. I'm gonna replace the contact form plugin I'm using. probably the worst one I ever tried.

  16. ydubois
    Posted 5 years ago #

    Hey! If you want to ask questions and get focused answers about my plugin, you'd better post on the official plugin community support page, as explained in the docs:


    I unfortunately have no time to actively monitor different forums.

    My plugin is free and will always remain so btw ;-)

  17. You can subscribe to tags relating to your plugin so the posts come to you as needed.

    Also, some people are willing to pay for support. ;)

  18. ydubois
    Posted 5 years ago #

    Well Andrea, I like to keep all conversations, questions and answers pertaining to one of my plugins in one single place. I find it more convenient for users also. And I like it for this place to be my own support and development blog, where most users of this plugin already posted useful advices or fixes.

    As for billing support, I do provide personalized support to paying customers also. This is very clearly explained in the plugin help pages and on my site.

    However, development of this specific plugin is funded by customers that agree for it to remain freely available to all.

    I always prefer willing users to volunteer funding a new feature that will then be made freely available to all. I would rather suggest customers to sponsor an improvement to a freely available plugin, or make a donation to keep it free for all, rather than switch to the alternative commercial solution that you advertise.

    I guess it's just a slightly different approach to the same business. Although I do respect other models and the quality of alternative software available elsewhere, I would just prefer to keep commercial offers clearly distinct from a forum thread dedicated to support on a completely free piece of software.

  19. ydubois
    Posted 5 years ago #

    And to point other participants in this thread to a useful direction, please be aware that this plugin, as of version 3.x only deals with plugin OPTIONS, not in anyway with DATABASE TABLES. If you're searching for specific plugin options, you would rather have to parse the code for statements such as:


    Retrieving or setting option values through a direct SQL query is not a good implementation, and good plugins usually do not do it.

    I'm working on version 4 of this plugin right now, coming your way very soon (like before the end of the year). It WILL implement custom database table replication which is completely distinct from option replication.

  20. ydubois - No one is commenting on your choice to support your plugins on your site. In fact, there are quite a number of plugins and themes do that. It's perfectly fine and, in fact, that's how many people charge for support and make money. Perfectly acceptable business practice. Laudable even.

    Andrea was just saying 'Hey, you know it's okay to charge.'

    I will say that 2 months ago, when I originally ran into this topic, there were no directions to go to your site on the plugin page. Nice to see the change :)

  21. ydubois
    Posted 5 years ago #

    Well, I'm sorry but the link to the official support page has always been there on the plugin documentation, in the readme file, in the plugin source file, and in the plugin administration panel. Since this is part of the deal with that plugin's original sponsor (there is also a link to the web site of that customer), it was there from the very first release on.

    But there's always room for improvement, so I'll try to make that even more visible in future releases of my plugins. And maybe, as Andrea suggested, I'll subscribe to the WP forums to keep on telling everyone where it's all happening ;-)

    And I know it's OK to charge: that's written everywhere on the plugin's settings page. How do you think I make a living?

    Thanks anyway for stating that you know the plugin works, and for trying to help. I'm back to developing version 4 now.

  22. Yeah, I don't download the plugins most of the time. If someone has an ish, I go to the WP plugin page, read the faq (since a lot of the time, they answer the questions!) and if it says 'For support...' on those pages, I send 'em to you ;)

    (2 months ago, Otto was overhauling the plugin pages, so a lot of formatting got wiggy for a while. But. if there's a link on the plugin admin page then tsk!)

  23. ydubois
    Posted 5 years ago #

    Version 4.0.0 is out for beta testing. Try it out here:


    It does support replication of some plugins' specific database tables in addition to replicating standard WP Options. It also has many new settings including excluding specific blogs from replication.

Topic Closed

This topic has been closed to new replies.

About this Topic