Skip to content

Adminer, a simple but effective database manager


Last week I was asked for help to the invertigation group I work with at University of Cordoba UCO for setting up a  WordPress page, instead of Joomla. In order to access the files by FTP, I use Filezilla with success, but I didn’t know how to access the database for creating a backup (backup).

Adminer.php, an alternative to PhpMyAdmin

Suddently, I remenber a project called Adminer, a database manager that works with MySQL, MariaDB, PostgreSQL, SQLite, MS SQL Server and Oracle, everything in just a single PHP file, that the only requirement is PHP 4.3.3 or later.

Login en Adminer

Login in Adminer

If you don’t like the design, you can download different CSS files to modify the styles, and also, you can download several plugins to improve functionality. I like the jQueryUI one that beautify datepicker, foreign keys selector, o table filtering without modify the SQL query.

Trabajando desde Adminer

Trabajando desde Adminer

Once inside Adminer, I could deal with the Joomla database, create the backup without loosing anything. All it’s done by an option that allows you to export the whole database with several choices:

Exportar una base de datos desde Adminer

Exportar una base de datos desde Adminer

And, this way I solved my problem: access to MySQL database to create a backup.

Everything in a single file

The feature that call my attention was that Adminer Adminer is only a single file, so the install process is very easy: upload to the server the file and it’s done!

Maybe It’s not as beautiful nor spectacular as other desktop database managers, o with several options like phpMyAdmin, but I must admit that I like a lot this Adminer project, and I’m pretty sure I will use it!

Have a nice day!

Manejando Datos Newsletter

Noticias, entradas, eventos, cursos, … News, entrances, events, courses, …

Gracias por unirte a la newsletter. Thanks for joining the newsletter.