inserting large tables into mysql
Posted: Sat Aug 27, 2005 1:15 pm
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
Thanks