PDA

View Full Version : adding 23mb data into tables



PipSqueak
01-15-2006, 10:59 AM
Hi

I uploaded a 23mb file (with sql commands) onto my server then I tried running the text file through phpmyadmin's and it only added 1098 entries out of 11000 entries. Is there any solution to add all my entries in one go?

Thanks
Wei-Ni

VodaHost
01-15-2006, 11:10 AM
Try breaking it down into smaller chunks.

PipSqueak
01-15-2006, 12:43 PM
Bigdump worked well....
I knew about this from the thread: http://www.vodahost.com/vodatalk/mysql-php/3034-uploading-mysql-database.html

VodaHost
01-15-2006, 08:18 PM
Excellent!!!