Export Data from MySQL
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 -h
option:
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.
External links
The following external link provides additional information:
Updated 11 months ago