How to Select a Subset in MySQL. The Structured Query Language, used in the MySQL database, has great flexibility for selecting subsets of data from database tables.

First, access the MySQL console from the server hosting MySQL with the command: sudo mysql -u root -p Once at the MySQL console, create the new user with the command: ...

So instead, you'll likely want to back up MySQL databases individually by specifying the individual database name (or names) at the end of the command, instead of just --all-databases.