Import Controller Data with mysql

When you restore or migrate the Controller, you can import the data you exported with mysqldump.

Shut down your Controller before using the following command to import the data into a database:

$install/db/bin/mysql -u controller -p<ControllerDBpassword> < metadata_dump.sql

It will overwrite the tables. You can clone your installation to another host and test your restoration there.

Warning: A Controller that is installed with a custom MySQL data directory location requires additional flags.