Backup MariaDB Users

Jorg71's profile image Jorg71 posted 3 months ago in General Permalink

Hi there,

I want to export all Users of a DB and then import them on another Server.

Is this possible with HeidiSQL?

Jorg

ansgar's profile image ansgar posted 3 months ago Permalink

Yes, HeidiSQL has an export feature, which supports exporting to other servers, amongst files and directories. Just rightclick a table and click "Export database as SQL".

Jorg71's profile image Jorg71 posted 3 months ago Permalink

I know this feature, but how can I export all users with their passwords, roles and privileges? Is this possible with HeidiSQL?

Please login to leave a reply, or register at first.