mysqlpump how to ignore database's name?

Viewed 101

mysqlpump's backup has database's name like:

INSERT INTO `database`.`table` ...

how to ignore database's name?

why I do not use mysqldump? because mysqldump will back up definer of view and I don't want it. useing mysqldump can ignore definer of view.

1 Answers

You can have mysqlpump ignore the definer with the "--skip-definer" option.

Unfortunately, I have not found a way to have it ignore the db name.

Related