MySQL Forums
Forum List  »  Newbie

Re: Is adminer safe to use with MySQL?
Posted by: Barry Galbraith
Date: June 23, 2023 06:56PM

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,

Options: ReplyQuote

Written By
Re: Is adminer safe to use with MySQL?
June 23, 2023 06:56PM

Sorry, only registered users may post in this forum.

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.