# Running SQL file from inside rake task

**URL:** <https://www.ruby-forum.com/t/running-sql-file-from-inside-rake-task/151105>\
**Category:** Rails\
**Created:** [October 16, 2008, 8:57pm UTC](https://www.ruby-forum.com/t/running-sql-file-from-inside-rake-task/151105 "2008-10-16T20:57:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![joep](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/87869e/32.png) [@joep](https://www.ruby-forum.com/u/joep)\
**Post date:** [October 16, 2008, 8:57pm UTC](https://www.ruby-forum.com/t/running-sql-file-from-inside-rake-task/151105/1 "2008-10-16T20:57:43Z")

</div>

My friends,

I have a rake task that I’m running to initialize some stuff for new  
servers.

I need to run a SQL file from inside that rake task. It’s just a big,  
raw SQL file.

How can I run the SQL file from inside the rake task?

Thanks in advance for any good advice.

---

<div class="post-metadata">

**Author:** ![joep](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/87869e/32.png) [@joep](https://www.ruby-forum.com/u/joep)\
**Post date:** [October 16, 2008, 10:20pm UTC](https://www.ruby-forum.com/t/running-sql-file-from-inside-rake-task/151105/2 "2008-10-16T22:20:00Z")

</div>

`mysql -uroot databasename < sqlfile.sql`

---

<div class="post-metadata">

**Author:** ![joep](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/87869e/32.png) [@joep](https://www.ruby-forum.com/u/joep)\
**Post date:** [October 17, 2008, 1:12am UTC](https://www.ruby-forum.com/t/running-sql-file-from-inside-rake-task/151105/3 "2008-10-17T01:12:18Z")

</div>

ActiveRecord::Base.connection.execute( )