How to export a database using Adminer?

Question

The first time I use ADMINER.

I want to export a database, and I'm not sure about setting the parameters correctly.

The database is in production and I do not want to make any mistakes.

See screenshot:

What are the correct options for:

1) Database: use, delete + create, create, create + change

2) Table: drop + create, Create, Create + alter

3) Data: Truncate + Insert, Insert, Insert + Update

Answer 1

For your comment or original question:

I want to export the database and import it in phpMyAdmin in my local environment to test and modify my client website. 

You want to recreate the database and data in a new environment and export SQL. Therefore, you will need to create tables in which they do not exist, or discard and overwrite the data if they exist.

To accomplish this, you want to select the following options:

Database: Drop + Create - this will result in DROP statements in the exported SQL before CREATE operations. This means that any existing databases with the same name will be deleted and all tables will be discarded. This is what you want to do if you want to create a clean test environment that matches performance.

Tables: Drop + Create - for the same reason as above

Data: Insert - this inserts all the data from your production database into the test copy database.