Moodle Adminer

General plugins (Local) ::: 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/MariaDB, PostgreSQL, Oracle and MSSQL.

Latest release: 4 months

4394 sites

2k downloads

110 fans

Current versions available: 10

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/MariaDB
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

Automated testing support

Early bird 4.1

Early bird 4.2

Early bird 4.3

Comments

sue sugizaki
Fri, 20 May 2016, 5:42 PM
I installed this at 3.0 and got an error...
Séverin Terrier
Fri, 10 June 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, 10 June 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, 20 Apr 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, 29 May 2017, 3:20 AM
Hi Oleksandr, in the new version export is available again.
Best regards
Guido Roessling
Sat, 25 Nov 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, 26 Nov 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, 30 Nov 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, 17 Mar 2018, 11:29 PM
Hi,

Any update to Moodle 3.4?

Ricardo
Gary Lynch
Thu, 30 Aug 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, 5 Nov 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, 6 Nov 2018, 6:32 AM
I am sorry but please use the bugtracker!
Christian Bocquet
Mon, 1 Apr 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, 2 July 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, 3 July 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!