RubyFlow The Ruby and Rails community linklog

Hasten: A gem to speed the import of large tables into mySQL

I just released the Hasten gem. Here’s a blog post about it.

You may find that someday you are working on a production application, and you want to do some testing on your local environment using production data. Furthermore, you may find that this application has a very large mySQL database, with tables that have many millions of rows. So, you export that database file from your production environment into a SQL file using mysqldump and copy it to your local computer. However, when you go to import that database into mySQL like so ‘cat database_dump.sql mysql -uroot’ it takes many hours to import…..

Post a comment

You can use basic HTML markup (e.g. <a>) or Markdown.

As you are not logged in, you will be
directed via GitHub to signup or sign in