This article describes how to import the data of an existing MySQL database into a Cloud Database. If you haven't already created a Cloud Database instance and an empty database to receive the imported data, you'll need to do that first.
The import process includes the following steps:
mysqldump -u username -p database_name > database_name.sql
database_name is the name of your existing datatabase. database_name.sql will be the name of the exported database file. Replace "username" with the username you use to access the original database.
On Ubuntu and Debian, install the client with the following command:
sudo apt-get install mysql-client
On Fedora and CentOS, install the client with this command:
sudo yum install mysql
mysql -h 31blah2d.rackspaceclouddb.com -u username -p database_name < database_name.sql
The database is imported and ready to accept new data.
© 2011-2013 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License