Home > FAQs > How do I prepare a MySQL dump file to use with the MySQL ServerTemplates?

MindTouch
Copyright (c) 2006-2014 MindTouch Inc.
http://mindtouch.com

This file and accompanying files are licensed under the MindTouch Master Subscription Agreement (MSA).

At any time, you shall not, directly or indirectly: (i) sublicense, resell, rent, lease, distribute, market, commercialize or otherwise transfer rights or usage to: (a) the Software, (b) any modified version or derivative work of the Software created by you or for you, or (c) MindTouch Open Source (which includes all non-supported versions of MindTouch-developed software), for any purpose including timesharing or service bureau purposes; (ii) remove or alter any copyright, trademark or proprietary notice in the Software; (iii) transfer, use or export the Software in violation of any applicable laws or regulations of any government or governmental agency; (iv) use or run on any of your hardware, or have deployed for use, any production version of MindTouch Open Source; (v) use any of the Support Services, Error corrections, Updates or Upgrades, for the MindTouch Open Source software or for any Server for which Support Services are not then purchased as provided hereunder; or (vi) reverse engineer, decompile or modify any encrypted or encoded portion of the Software.

A complete copy of the MSA is available at http://www.mindtouch.com/msa

How do I prepare a MySQL dump file to use with the MySQL ServerTemplates?

Table of Contents

Background Information

The easiest way to run a MySQL database on a cloud instance is to use RightScale's MySQL ServerTemplates.  The MySQL Database Setups tutorials assume that you already have a MySQL dump file that you can use to set up your database in the cloud.  If you do not have a MySQL dump file, use the following instructions to create one.

Answer

The steps below explain how to create a MySQL dump file, which can then be used to initialize databases using RightScale's MySQL ServerTemplates.

You may create and compress your MySQL dump files by following these steps:

1. From the command line on the machine where MySQL is installed (locally or in an SSH session), run:

mysqldump -uusername -ppassword <database name> --opt > myDBDump

Then, you can check the output file with a text editor to verify the integrity of the data.

Next, in order to streamline the data-transfer process, use gzip to compress the dump file:

gzip -c myDBDump

Then, you will need to upload the myDBDump.gz file to an S3 bucket. When you create your MySQL database on the database server, you will run a script ("DB Create MySQL EBS Stripe volume") that will create and attach volumes that will be used to store your MySQL data. 

Alternatively, you may combine the above steps into a single command; however, do not forget to upload the generated dump file to an S3 bucket when you are finished creating it.

mysqldump -uusername -ppassword databasename | gzip -c > myDBDump.gz
You must to post a comment.
Last Modified
13:54, 7 Oct 2014

Tags

Classifications

This page has no classifications.

Announcements

None

Glossary | 用語용어 Site Map | Site Help Community Corporate Site Get Support Dashboard Login
Doc Feedback Product Feedback Resources MultiCloud Marketplace Forums

Dashboard Status


© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.