Control Web Panel

WebPanel => MySQL => Topic started by: Namaste on April 11, 2025, 01:33:19 PM

Title: howto export all databases and users with privel
Post by: Namaste on April 11, 2025, 01:33:19 PM

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

Title: Re: howto export all databases and users with privel
Post by: overseer on April 11, 2025, 09:31:08 PM

CWP -> CWP Migration under AlmaLinux 8.

Title: Re: howto export all databases and users with privel
Post by: Namaste 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.

Title: Re: howto export all databases and users with privel
Post by: rcschaff 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

Title: Re: howto export all databases and users with privel
Post by: Namaste on April 13, 2025, 11:28:34 AM

Quote from: rcschaff 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

Thanks.  your post will help others too.