how to create new mysql db (clone current) from within rails app?

Question

I need to clone current database, and assign it a new name. How to do this from within rails app?. Or maybe I need to run some bash mysqldump -h [server] -u [user] -p[password] db1 | mysql -h [server] -u [user] -p[password] db2 ? if so, how to implement it (run from rails model)?. Thanks for help.

techvineet · Accepted Answer · 2013-09-09 09:21:04Z

1

There is not direct method to do this in Rails. MySQL mysqldump utility works best in these cases.

answered Sep 9, 2013 at 9:21

techvineet

5,1112 gold badges32 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Andrey Yasinishyn Over a year ago

blame.. I hoped that this magic exists )). So the issue now is - how to run this command from within rails model (I need it to be a model:) ).

Andrey Yasinishyn Over a year ago

can I user exec('ls ~') ??

techvineet Over a year ago

Why you want to make it in models? Will you run it too often?

Andrey Yasinishyn Over a year ago

Once a year, but I want to store all the logic in one model. It will be peaty hairy.

Andrey Yasinishyn Over a year ago

Ok, I find an solution here Execute shell commands

Collectives™ on Stack Overflow

how to create new mysql db (clone current) from within rails app?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related