CodeIgniter Forums

Full Version: Import database data from SQL file
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]Unknown[/eluser]
Hi, can somebody please help me.

I'm new in CI and I want to create database tables from other projects. I have SQL dump file with 2000 commands and phpMyAdmin is falling down with it. Is there a way how to solve it in CI?

Thanks a lot for any ideas.

El Forum

[eluser]awpti[/eluser]
Well, this is more of a generic question.

The better answer would be to break up the SQL file into 2 or more pieces (to fit within the default 2MB limit of phpMyAdmin).

Coding something to do it would be more time consuming, by far, than manually breaking the file up.