How to Migrate from SQLite DB to MySQL?

How hard is it to migrate from a EC2/EBS DB setup to one using RDS?

• This is a follow-up question to .

• Answer:

  Airbnb migrated from a MySQL server on EC2 to an RDS instance back in November 2010.  We did a writeup of our reasoning and migration process on our engineering blog: http://nerds.airbnb.com/mysql-in-the-cloud-at-airbnb The other answers do a good job explaining the advantages and disadvantages of managing your own MySQL instance vs. using RDS, but there's not much talk about the actual migration process.  Here's one excerpt from our post that is probably useful in that regard: Everything is straightforward if you are setting up a site for the first time, but what if you have an existing database with gigabytes of data that you want to migrate to RDS? This is where the fun begins. At the time we did the migration, we already had gigabytes of data and some tables with millions of records. RDS instances only expose MySQL and don't give you direct access to the machine via SSH or other tools, so unfortunately there is no way to do this on the file system level. The only practical way to move your data over is to do a mysqldump on the source machine, followed by a mysqlimport in RDS. This can take a significant amount of time if you have a lot of data, and unless you want to spend days or weeks figuring out a complex migration strategy, the only option is to take down the site during the process. We wanted to keep the downtime as low as possible, so we looked for simple ways to transfer a significant amount of our data while the site was still running. We came up with the idea to copy the data in tables that never receive UPDATEs or DELETEs, so we would only have to copy the diff later on. Once those tables were carefully selected, the procedure was pretty straightforward. The actual script that we used to do our migration is available at https://gist.github.com/671874 This approach allowed us to perform the whole migration with only 15 minutes of downtime.