Export Data from MySQL

  • Last updated on: 2018-04-18
  • Authored by: Rackspace Support

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

Note: 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:

Continue the conversation in the Rackspace Community.