/ Tools

Adminer - A single file database management tool

I've shifted to Adminer from the wildly popular phpMyAdmin.

For importing an existing database export, as mentioned here, put the file in the same location where adminer lives. (for me it was /usr/share/adminer). Also, you need to rename the file as adminer.sql.gz. This isn't exactly user friendly, but I can live with that! :-)

Tips:

  • Extract bz2 file using bzip2 -d tobwis_production_2016-02-08_10-08\ AM.sql.bz2
  • Move the extracted sql file using mv extracted_db_dump.sql /usr/share/adminer/adminer.sql