General plugins (Local): Moodle Adminer

local_adminer
Maintained by Picture of Andreas GrabsAndreas 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.
1756 sites
1k downloads
55 fans
Current versions available: 8
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. Here are some of the key-features: 1) you can define trigger 2) you can change the order of fields 3) you can easy create or alter views 4) you can create stored procedures 5) if you rename a database so the database is altered and not copied like phpMyAdmin it does 6) 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 running the notification-page. After the installation you will find a new link "Moodle Adminer" below "Site administration -> Server".

Screenshots

Screenshot #0
Screenshot #1
Screenshot #2
Screenshot #3
Screenshot #4
Screenshot #5
Screenshot #6
Screenshot #7

Contributors

Picture of Andreas Grabs
Andreas Grabs (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of sue sugizaki
    Fri, May 20, 2016, 5:42 PM
    I installed this at 3.0 and got an error...
  • C'est moi :-)
    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?
  • Picture of 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
  • Picture of 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
  • Picture of Andreas Grabs
    Mon, May 29, 2017, 3:20 AM
    Hi Oleksandr, in the new version export is available again.
    Best regards
  • Picture of 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).
  • Picture of 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.
  • Picture of 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 wink
  • Ricardo Caiado
    Sat, Mar 17, 2018, 11:29 PM
    Hi,

    Any update to Moodle 3.4?

    Ricardo
  • Picture of 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'
  • Picture of 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
  • Picture of Andreas Grabs
    Tue, Nov 6, 2018, 6:32 AM
    I am sorry but please use the bugtracker!
  • Picture of 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']);
  • Picture of 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?
  • Picture of 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!
1 2 3
Please login to post comments