Magento include a .sql file in setup script

Question

I am wondering if there is a way to define a .sql file as source in a setup script. I have a huge .sql file and I don't think it is pretty to paste it in my php as this.

my file is composed of 60k insert into lines.

Of course I know I can do a fopen on my .sql file, so I am not blocked but I was wondering if there is a native functionality that can do it.

Thanks

Mukesh · Accepted Answer · 2016-01-18 13:46:10Z

1

If you are developing a custom module in Magento and you want to import some records in the Magento with your module.Then you can accomplish this using following approach.

Create a .sql file at the mentioned location in your module.

app/code/local/Namespace/Modulename/data/modulename_setup/data-install-1.0.sql

INSERT INTO sample_table (id, value) VALUES (1, 'one');
-----
-----

First try a test run on development environment with only few lines of sql query.(As you are having 60K lines in your file.)

I found this solution on blog by Ryan.

Please refer for more information Magento Installation Scripts

answered Jan 18, 2016 at 13:46

Mukesh

7,84623 gold badges111 silver badges167 bronze badges

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

Collectives™ on Stack Overflow

Magento include a .sql file in setup script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related