How to download MySQL db from Rails app in Cloud9 IDE

Question

How can i download the MySQL db from a rails app in C9 (and then open locally in MySQL Workbench)?

I want to improve my skill in writing "raw SQL" queries and this would provide a lot of familiar data to play with.

Answer 1

Just export the db to a local file in c9, and then import it back on Your machine:

export:

mysqldump -u username -p databasename > backup.sql

import:

mysql -u username -p databasename < backup.sql