Bug #98621 Add option for relative table names
Submitted: 16 Feb 2020 12:15 Modified: 17 Feb 2020 6:07
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqlpump Command-line Client Severity:S4 (Feature request)
Version:8.0.19 OS:Any
Assigned to: CPU Architecture:Any

[16 Feb 2020 12:15] Daniël van Eeden
With mysqldump I can do this:

mysqladmin create copy_of_test
mysqldump test | mysql copy_of_test

With mysqlpump the "CREATE TABLE" statements are qualified with the schema name.
This makes it hard to restore in another schema.

This is useful when:
- Creating a copy for acceptance/test/etc
- Creating a copy as part of a migration
- Restoring into another schema and then picking a subset of tables to restore to the 'real' schema.
- Being able to restore a backup and then compare the current data against it.

How to repeat:
Try to use mysqlpump to restore into a different schema

Suggested fix:
Add --relative-table-names option
[17 Feb 2020 6:07] MySQL Verification Team
Hello Daniël,

Thank you for the feature request!