CodeIgniter Forums
Import database data from SQL file - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forum-21.html)
+--- Thread: Import database data from SQL file (/thread-5287.html)



Import database data from SQL file - El Forum - 01-15-2008

[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.


Import database data from SQL file - El Forum - 01-15-2008

[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.