Page 1 of 1

inserting large tables into mysql

Posted: Sat Aug 27, 2005 1:15 pm
by mikebr
I have a table that contains around 47,400 entries and comes in at 5MB, I can't seem to get this to inport in one go, it is a real pain having to break the table inserts down into small parts, can anyone offer some tips on importing data of this size. I have been using phpmyadmin and the page never actually seems to get through the process, it just seems to not do anything, even after leaving the page for 30 minutes. On checking the db there are no entries but as I say if I break the data down over about 10 files then they import.

Thanks

Posted: Sat Aug 27, 2005 1:40 pm
by feyd
hmmm... you could try creating your own import script. It could simply come down to an I/O timing issue, or could be a more serious issue with your version of phpMyAdmin.

Posted: Sat Aug 27, 2005 8:49 pm
by mikebr
The script won't run and yet from what I can see it should, I wonder if the server might be restricting things, if I use the sql window from phpmyadmin I can only update a max of about 1600 lines at a time or I get an internal server error so I guess they must be.

Thanks anyway
Mike