Examine this command, which executes successfully:
mysqlpump -–user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
Examine this command, which executes successfully:
mysqlpump -–user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
In the context of MySQL, certain system databases are excluded from dumps by default when using the mysqlpump utility. Specifically, the 'information_schema' and 'sys' databases are not included in such dumps. The 'information_schema' contains metadata about the database objects and is not typically included in backups. Similarly, the 'sys' database is a system database providing various system views and functions primarily for performance and monitoring purposes, which is also excluded by default. Therefore, the two databases that will be excluded from this dump are 'information_schema' and 'sys'.
Mysqlpump does not dump the performance_schema, ndbinfo, or sys schema by default. Mysqlpump does not dump the INFORMATION_SCHEMA schema. https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html#mysqlpump-restrictions
AD Does not dump performance_schema, ndbinfo, or sys, schema_information