Re: Is adminer safe to use with MySQL?
I'm not familiar with Adminer, so I just put it on my local server to test it.
A dump of one of local MySQL databases fails for the following reason.
My database uses character_set utf8mb4, so I can store emojis and stuff in character fields.
ADMINER gives me no option to set the character set for the connection, and sets the charcter set to utf8, which MySQL has aliased to utf8mb3 (for now).
The incorrect character set leads to some data being lost when I dump.
PhpMyAdmin reads the server character set and so connects as UTF8mb4, and no data is lost when I export.
But, the best way to backup your database is with mysqldump.
Good luck,
Barry.
Subject
Written By
Posted
Re: Is adminer safe to use with MySQL?
June 23, 2023 06:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.