How to export database with Adminer?

Question

It's the first time i use ADMINER.

I want to export the database and i'm not sure to set correctly the parameters.

The database is in production and i don't want to make any mistakes.

See screenshot :

enter image description here

What are the correct parameters for :

1) Database : Use, drop + create, Create, Create + alter

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

3) Datas : Truncate + insert, insert, insert+ update

@MarkMurfin I want to export the database and import it in phpMyAdmin in my local environment to test and modify my client's website. Why the downvote ? It would be nice to answer this question if you have the answer. — Sébastien Gicquel, Feb 10 '15 at 13:30
Try this [link](http://stackoverflow.com/questions/14705886/how-to-export-part-of-a-table-as-sql-in-adminer/36053121#36053121) — Muhammad Shahzad, Mar 17 '16 at 06:32

score 20 · Accepted Answer · edited Feb 15 '21 at 07:58

20

Per your comment on or original question:

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

You want to recreate the database and data in a new environment and you are exporting SQL. Therefore, you will want to create tables where none exist, or discard and overwrite data if it does exist.

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

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

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

Data: Insert - this will insert all data from your production database into your test copy database.

edited Feb 15 '21 at 07:58

Dmitry

6,716
14
37
39

answered Feb 10 '15 at 13:35

Mark Murfin

776
8
19

3

Thank you, i can now export database. I know it was a newbie question but i was afraid to do something wrong. My client has no backup and i know we can never be too cautious – Sébastien Gicquel Feb 10 '15 at 13:48
4

what about that Auto Increment Option? – Banee Ishaque K Nov 03 '17 at 17:09
What about routines, events and triggers? Can we check those boxes safely or will they cause any code to execute also on the production server? – Redoman Nov 22 '22 at 02:16

How to export database with Adminer?

1 Answers1