The following is an example of how to use
mysqldump to export all databases in the
repository instance to a dump file named
This example assumes you are using the MySQL instance solely as the repository for MySQL Enterprise Service Manager and not for any other purpose. This is the recommended implementation.
shell> mysqldump --single-transaction -uservice_manager -pPassword -P13306 -h127.0.0.1 —all-databases > mem.dump
The above command creates a file,
containing all of the MySQL Enterprise Monitor data.
To restore the dump file, run the following mysql command on a clean instance:
shell> mysql -u <user> -p -P13306 -h127.0.0.1 < mem.dump
You should also backup the following files:
You can also use MySQL Enterprise Backup to manage your repository backup process. For more information, see the MySQL Enterprise Backup documentation.
It is also possible to shut down MySQL Enterprise Service Manager, copy the entire data directory to another location, and restart. To restore the copy, simply shut down MySQL Enterprise Service Manager and overwrite the data directory with the backup, and restart. This is the same process used by the MySQL Enterprise Service Manager upgrade installer.