I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so.
How can I easily export all the databases for just this specific user? I've been looking at
mysqldump but it seems to require that I specify the databases individually. Is there a way to just dump them all at once into separate .sql files, but just for the one user?
A few notes:
- users do not have SSH/CLI access
- There is a problem currently preventing me from exporting via PHPMyAdmin
- This user's account has been compromised so I want to get him off the server ASAP, but give him his DBs so he can rebuild elsewhere