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

Initialize Master-DB contents

Objective

To manually initialize the contents of a MySQL database.

Background

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

The easiest way to initialize the contents of the Master-DB is to follow the appropriate "stripe" MySQL Database Setups tutorial.

Steps

  1. Go to your Deployment (Manage -> Deployments).
  2. SSH into the running Master-DB server.
  3. Download the initial DB contents into the local disk (i.e., /mnt/ ) using scp, ftp, or rsync from an external source.
  4. Install the downloaded contents into the MySQL server by creating the database 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 you've completed the steps above, the Master-DB instance should be serving the contents of the downloaded DB file.  To confirm, connect locally to the MySQL server and show the list of databases/schemas that it's currently 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
14:09, 7 Oct 2014

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.