Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > ServerTemplates > Archive > Pre-11H1 > MySQL-EBS v1 (No Stripe) > Manager for MySQL-EBS Runbook > MySQL-EBS Recipes > Initialize Master-DB contents

Initialize Master-DB contents

There are several different ways to manually initialize the contents of a MySQL DB.  This document describes a simple way of accomplishing this task.   Experienced DBA's can choose their preferred method to accomplish the same task.

Instructions

Connect to the active master DB instance.

  1. Go to your deployment (Manage -> Deployments).
  2. Find the MySQL-EBS "master" instance and click on the "SSH Console" icon ssh_console_icon.gif to open a direct Unix SSH console to the running instance


Download the initial DB contents into the local disk (i.e., /mnt/ ).

  1. Use scp, ftp, or rsync from an external source.


Install the downloaded contents into the MySQL server.

  1. By creating the schema and applying the MySQL dump file (if that's the format of the download), or perhaps by replacing the base directory if the downloaded contents are in binary format.

What feedback to expect

After this recipe is complete, the master DB instance should be serving the contents of the downloaded DB file. An easy way to confirm it is to locally connect to the mysql server and show the list of databases/schemas it is serving. For example: echo "show databases;" | mysql -u root. You should be able to find the name of the imported DB in the list of database names.

You must to post a comment.
Last modified
21:34, 16 May 2013

Tags

This page has no custom tags.

Classifications

This page has no classifications.

Announcements

None


© 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.