To export your MySQL database, use the following MySQL command:
mysqldump -u root -p database_name > database_name.sql
database\_name is the name of your existing database.
database\_name.sql is the name of the exported database file.
If your database resides on a remote host (as it would if you're using Cloud Databases), specify the hostname with the
mysqldump -h host_name -u username -p database_name > database_name.sql
In this command, insert the username that you created.
You can also set the
MYSQL\_HOST environment variable to the remote host's address so that you don't have to enter it on the command line.
If you want to import this data to another database, see Import data into Cloud Databases.
The following external link provides additional information:
Updated 3 months ago