Moodle plugins directory: Moodle Adminer

General plugins (Local): Moodle Adminer

local_adminer

Maintained by

Andreas Grabs

This plugin is based on the great tool adminer. The main advantage of this plugin is, it can handle different types of database. So it works with MySQL, PostgreSQL, Oracle and MSSQL.

1981 sites

1k downloads

66 fans

Current versions available: 8

Download

This plugin is based on the great tool adminer. The main advantage of this plugin is, it can handle different types of database.
So it works with:

MySQL
PostgreSQL
Oracle
MSSQL

Here are some of the key-features:

you can define trigger
you can change the order of fields
you can easy create or alter views
you can create stored procedures
if you rename a database so the database is altered and not copied like phpMyAdmin it does
you can define foreign key with referential integrity

To install it you only have to copy it into the "local" folder in your moodle-installation and call the notification-page. After the installation you will find a new link "Moodle Adminer" below "Site administration / Server".

Useful links

Source control URL

Bug tracker

Screenshots

Contributors

Andreas Grabs (Lead maintainer)

View other contributions

Please login to view contributors details and/or to contact them

Awards

Comments

sue sugizaki
Fri, May 20, 2016, 5:42 PM
I installed this at 3.0 and got an error...
Séverin Terrier
Fri, Jun 10, 2016, 4:08 PM
Hi Andrea,
Adminer is a really great and useful tool!
Do you plan to make it officially compatible with Moodle 3.0 and 3.1, so that it can be installed/upgraded via the build in installer?
Andreas Grabs
Fri, Jun 10, 2016, 6:24 PM
Hi Séverin,
I am sorry for the long running. I am very buisy and I wanted the plugin compatible with php7. So it is now.
Best regards
Oleksandr Szpinkowski
Thu, Apr 20, 2017, 1:58 PM
Good day. Please,tell me how to make a memory dump in 3.1? Why in 3.1 there is no option Dump as in 2.7?
Thank you
Andreas Grabs
Mon, May 29, 2017, 3:20 AM
Hi Oleksandr, in the new version export is available again.
Best regards
Guido Roessling
Sat, Nov 25, 2017, 5:15 PM
The current version throws several warnings when used under 3.4; is there any chance that this will be fixed? (I currently apparently cannot do anything after selecting the database).
Andreas Grabs
Sun, Nov 26, 2017, 3:40 AM
Hi Guido, can you give me a little more information. Unfortunately I can't reproduce your problem.
What DBMS do you use, what error appears a.s.o.
Guido Roessling
Thu, Nov 30, 2017, 3:34 AM
Oops. Forget it - for some reason, it was version 2.9. No idea why I was using such an old version - and why no updates were shown... Note: even that version worked with PostgreSQL 9.4.15, PHP 7.0.25 and Moodle 3.4
Ricardo Caiado
Sat, Mar 17, 2018, 11:29 PM
Hi,

Any update to Moodle 3.4?

Ricardo
Gary Lynch
Thu, Aug 30, 2018, 6:12 PM
I have installed with 3.5 and have this error when i try to use 'Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "blah", database "postgres", SSL off'
Ruthine Burton
Mon, Nov 5, 2018, 10:03 PM
Hi, the hosting company for our Moodle (3.5) have let me know that Adminer appears incompatible with the Adaptable theme (latest version for Moodle 3.5). They had to uninstall it as it would hang the programme. This is a great plugin that I have used previously. Do you have any plans for updating it to be compatible with Adaptable? Thank you. Ruthine
Andreas Grabs
Tue, Nov 6, 2018, 6:32 AM
I am sorry but please use the bugtracker!
Christian Bocquet
Mon, Apr 1, 2019, 8:34 PM
Hi Ruthine, to make this plugin compatible with the Adaptable or Essential theme, try to remove lines 56 and 57 from the templates/adminer.mustache file:
56 require(['theme_boost/modal']);
57 require(['theme_boost/loader']);
Michael Milette
Tue, Jul 2, 2019, 10:58 PM
Hi Andreas! Is there a reason that the version here on Moodle.org is one version ahead of the version on GitHub?
Andreas Grabs
Wed, Jul 3, 2019, 3:16 AM
oops, I forgot to push it to github. I only pushed it in my private repostory.
Now it is up to date.
Thank you Michael for this info!

Please login to post comments