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 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
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
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!