Featured templates

What is adminer and how to use it

Margarett Ortiz April 4, 2016
Rating: 4.0/5. From 4 votes.
Please wait...

Hello! This tutorial will show you what is Adminer and how to use it.

What is adminer and how to use it

Adminer is a tool for managing contents of MySQL databases, formerly known as phpMinAdmin. It’s a single tiny PHP file. In order to import, export tables and execute SQL commands without phpMyAdmin using Adminer, please follow the steps below:

  1. Download Adminer PHP files from this website.

  2. Upload the PHP file to your root web directory (e.g. www/html/…).

  3. You can either zip & upload your SQL file to directory, where you’ve uploaded adminer.php, or you can find and upload it using Adminer page later.

  4. Open your browser and access Adminer PHP file, e.g.

  5. Log into Adminer with your credentials. You’ll see a window that looks similar to phpMyAdmin home window:

  6. Here you can do all the necessary actions, for example, dump, import and create tables, run SQL commands, etc.

  7. If you don’t have a backup SQL file and want to take it from your previous site, upload Adminer to your previous server and click on Dump. After this, a backup file of you database tables will be created.

  8. Now, you can import the backup file by clicking on Import button:

  9. If you previously uploaded the SQL file to your server, click on Run file or click on Choose file to upload the old SQL file. Then, click on Execute button.

  10. You can run SQL commands that you need by just clicking SQL Command. You will see a text field to execute the SQL command:


Feel free to check the detailed video tutorial below:

What is adminer and how to use it
This entry was posted in Working with Files and tagged Adminer, database, tool. Bookmark the permalink.

Submit a ticket

If you are still unable to find a sufficient tutorial regarding your issue please use the following link to submit a request to our technical support team. We'll provide you with our help and assistance within next 24 hours: Submit a ticket