inserting large tables into mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mikebr
Forum Contributor
Posts: 243
Joined: Sat Sep 28, 2002 7:05 am

inserting large tables into mysql

Post 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
Last edited by mikebr on Sat Aug 27, 2005 4:42 pm, edited 1 time in total.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
mikebr
Forum Contributor
Posts: 243
Joined: Sat Sep 28, 2002 7:05 am

Post 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
Post Reply