how to change databse default stroage in adminer?

thcom
Backer | 94
+
0
-

hi

does anybody know, how to change storage (Aria, INNODB, memory etc ..) in mysql, mariaDB with adminer ?

many thanks

Keeehi
Member | 36
+
0
-

It is on the page where you can edit the table (adding/removing columns etc.) Next to the table name.

thcom
Backer | 94
+
0
-

Keeehi wrote:

It is on the page where you can edit the table (adding/removing columns etc.) Next to the table name.

i asked wrong

i mean change storage for whole database

is it possible ?

CZechBoY
Member | 3608
+
0
-

you mean defaul storage?

thcom
Backer | 94
+
0
-

CZechBoY wrote:

you mean defaul storage?

yes, otherwise I need change it in every new table in DB

Keeehi
Member | 36
+
0
-

When you create new table and you select some engine option, adminer saves this option to cookie adminer_engine and if you then create another table, the engine is preselected and therefore all other tables created with adminer UI will be created with this engine. As long as the cookie stays in your browser.
Obviously, it works only in your browser and if you use UI to create the table. If you use SQL query without specified engine, adminer won't help you. You would have to change the default storage option if mysql config as @DavidMatějka sent.