Find solution
How to Migrate from SQLite DB to MySQL?

What do you suggest to migrate an amazon RDS instance to a non-amazon DB with a live website?

  • Does anyone have any ideas on migrating a RDS instance to a non-amazon mysql server. The db has both myisam and innodb tables.

  • Answer:

    Without having more info as to the number of records or db size, the process will be similar to a move made on any db. You can either take a full backup or do a server to server copy. I'd do either and test the new environment with the app to ensure nothing is broken. Depending on how long that takes, use a differential backup or data copy to write the new transactions that took place during the testing process. Or, do an initial copy, test for as long as you like, and then do another new full copy, and again, another differential copy backup/restore. That very, very broad overview is the best way I have seen to minimize downtime.

Shannon Sofield at Quora Visit the source

Was this solution helpful to you?

Other answers

You can now use replication features to get your outside instance synced up to your RDS production instance, before detaching the two and shifting over your app? This document is written just for you: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html The only caveat is you'll need to be running MySQL 5.6.

Neal Magee

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.