Author Topic: howto export all databases and users with privel  (Read 97 times)

0 Members and 1 Guest are viewing this topic.

Offline
***
howto export all databases and users with privel
« on: April 11, 2025, 01:33:19 PM »
Thinking about migrating to another host.  Whats the best way?
Listen to everything Pixelpadre says.

Offline
*****
Re: howto export all databases and users with privel
« Reply #1 on: April 11, 2025, 09:31:08 PM »
CWP -> CWP Migration under AlmaLinux 8.

Offline
***
Re: howto export all databases and users with privel
« Reply #2 on: April 11, 2025, 09:53:59 PM »
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.
Listen to everything Pixelpadre says.

Offline
****
Re: howto export all databases and users with privel
« Reply #3 on: April 12, 2025, 04:51:04 AM »
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
Google Hangouts:  rcschaff82@gmail.com

Offline
***
Re: howto export all databases and users with privel
« Reply #4 on: Today at 11:28:34 AM »
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.
Listen to everything Pixelpadre says.