howto export all databases and users with privel

[Namaste]

Thinking about migrating to another host.  Whats the best way?

[overseer]

CWP -> CWP Migration under AlmaLinux 8.

[Namaste]

I looking more at the dbase migration.  I can grab the public_html folder with ssh.  Done it in the past, fast and furious.  But thats just for folders.

Basically, I want to know how to dump all/some databases with the users.  I exported from phpmyadmin and I dont get any users. I read on line that mariadb is supposed to export users with export.

[rcschaff]

mysqldump --system=users --insert-ignore --all-databases >  alldatabase.sql


More info can be found here:

https://dba.stackexchange.com/questions/299650/mysqldump-all-database-including-user-password-and-grants

[Namaste]

mysqldump --system=users --insert-ignore --all-databases >  alldatabase.sql


More info can be found here:

https://dba.stackexchange.com/questions/299650/mysqldump-all-database-including-user-password-and-grants

Thanks.  your post will help others too.