MYSQL - Querying multiple wordpress databases at once ?

Question

I need to execute an cleaning operation on my mysql databases,

I have 140 wordpress databases under the same connection.

I have ~30 forbidden words.

I need to query all wp-post tables post-content columns find these 30 words, and remove the rows that include one of these words.

I must do it on each databases at once!

Stainedart · Accepted Answer · 2011-11-14 03:34:10Z

1

You could write a small program in java or c# to actually loop through all the databases.

If you execute show databases; this will retrieve all the databases that are present on you connection. From there I assume you know the tables on which you want to query for your forbidden words. Then you can loop within this new application for each database present and you will be able to query the wanted table.

Let me know if this is what you were expecting. If you want some code sample let me know.

answered Nov 14, 2011 at 3:34

Stainedart

1,9994 gold badges32 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Stainedart Over a year ago

I forgot to add to this you need to be connected with a user that has privililedges on all those database to not encounter an access denied sort of error and please do not use root as this is a bad pratice. It is good for development purposes but not for production environments

seyfigo Over a year ago

Thank you so much Carl,but i found a programmer who will develop an interface with few more advanced options, i will let you know if i need help.

Collectives™ on Stack Overflow

MYSQL - Querying multiple wordpress databases at once ?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related