How to execute .sql file script in Phoenix?

You can create a migration to run your .sql file as long as the database exists. Something like:

Create your migration:

iex> mix ecto.gen.migration my_database_structure_migration

Then edit the migration in priv/repo/migrations/2017xxxxxxxxxxx_my_database_structure_migration.exs to be something like the following:

defmodule My.Database.Structure.Migration do
  use Ecto.Migration

  def up do
    execute File.read!("/path/to/sql_dump.sql")
  end

  def down do
    
  end
end