TurnKey Linux Virtual Appliance Library

Migrate from MySQL appliance to Rails appliance

chad.tipton's picture

I have data in a MySQL appliance and would like to migrate it to a Rails appliance.  Can I use TKLBAM to backup and then restore onto the Rails appliance?

Jeremy Davis's picture

It should work...

Although assuming that it is just the DB you wish to migrate you could force it to just restore the files (check the TKLBAM docs for how to do that).

The other way that you could go is just do a DB dump (from the commandline or phpMyAdmin) on your MySQL appliance then import it into your Rails appliance (again either by commandline or phpMyAdmin - assuming the Rails appliance has phpMyAdmin).

Obviously to be on the safe side ensure that your Rails data is backed up (and that it restores ok) before you do anything. Perhaps the best way to go is test on a local VM first by installing Rails, restoring your Rails backup, then overwrite it with your MySQL backup and test that the process works as expected prior to do it on your production server.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)