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.
Connect to the active master DB instance.
Download the initial DB contents into the local disk (i.e., /mnt/ ).
Install the downloaded contents into the MySQL server.
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.
© 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.