AdminerEvo automatization

Support
, ,
1

First of all, it is an unexpected and big luck, that AdminerEvo allows management of other databases, beside of the WP’s own one!

Now my biggest issues is nearly fixed - I need to manage two databases, standalone and those of WP in one tool.

Now the last step, automatization.
I need automatically (daily) SELECT something from the standalone db, and UPDATE in the WP’s db.

How would you go on it?

Currently I see only a way to run a bash script with Windows Scheduler. But maybe somebody knows a more smart way.

2

Hi @EvgeniyO

I’ll leave this open in case someone from the community has any thoughts, but from our team’s end we don’t have any other specific workflows to offer for this. The Bash Script might be worth trying out if you’re comfortable. In fact if you’re comfortable creating a script to read and write both databases directly you likely don’t even need AdminerEvo.

3

Hi @Nick-B !
There is an Event Scheduler in MySQL 8, like this one: https://dev.mysql.com/doc/refman/8.4/en/create-event.html.

Do you maybe have any info about accessing it in the LocalWP / MySQL environment?