How can I find out the names of database tables a plugin is using?

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.

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.

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. https://www.freewebmasterhelp.com/tutorials/phpmysql

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?

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.

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

https://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.

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.:)

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.

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.:)

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.

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

I tweeted you!

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

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:

https://www.yann.com/en/wp-plugins/yd-wpmu-sitewide-options

I unfortunately have no time to actively monitor different forums.

My plugin is free and will always remain so btw ??