If this tutorial is not what you were looking for, you still have any questions, suggestions or concerns - feel free to let us know. Please help us to serve you better!

Your Name

Your Email

Your Message (required)

captcha

Featured templates

What is adminer and how to use it

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. yoursite.com/adminer.php.

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

    What_is_adminer_and_how_to_use_it_1
  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:

    What_is_adminer_and_how_to_use_it_2
  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:

    What_is_adminer_and_how_to_use_it_3

Feel free to check the detailed video tutorial below:

What is adminer and how to use it
 
Live Chat
We help you to choose the right product.
Start chat