Export a MySQL Database Hosted on ScaleGrid

Export your MySQL hosting database at ScaleGrid and save it as a .sql file on your own server.

In order to perform the export, you will need to download and install the mysqldump utility. Before you begin, you must also ensure that the network connectivity is working fine between your current server and the ScaleGrid deployment by following these instructions.

Dump your ScaleGrid database to a file using the command:

mysqldump -h <ScaleGrid hostname> -u <ScaleGrid Admin User> -p<ScaleGrid Admin Password> --databases <Your DB Name> --single-transaction --set-gtid-purged=OFF > Your_DB_NAME.sql

Refer to this help doc to get the hostname of your ScaleGrid deployment, and this help doc to find the admin username and password for your ScaleGrid deployment.