Import database data from SQL file

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

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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.