First off, does your mysql DB allow you to connect remotly (not including phpmyadmin). If so, I'd suggest www.anse.de/mysqlfront, and use that to connect to the database, and import the .csv through that. I can see the file maybe not fully uploading, due to possibly the max file size in php, as 100,000 rows of data must be approaching at least 1mb (might be wrong there too, depends on the data).
Jason Reid [EMAIL PROTECTED] -- AC Host Canada www.achost.ca ----- Original Message ----- From: "Thomas Edison Jr." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 11:20 PM Subject: [PHP] Importing CSV File : 100000 Rows! > Hi, > > I have generated a .csv file from a .dat file using a > VB program. Now this .csv file needs to be imported > into my mySQL Database Table on the internet, using > phpMyAdmin. > > The problem i'm facing is that the file, while > uploading, stops somewhere in the middle. The upload > just gets stuck. > > Possible reasons : > > 1. Number of rows is too large. About 100000. Does > mySQL Support these many rows? Is yes, is it possible > to upload these many rows from a client to a table on > the internet using phpMyadmin? > > 2. Internet connection. Due to the mere size of the > file in terms of no. or rows, maybe my internet is not > able to send all the data. I dont' know. > > Now can anyone suggest a possibly solution? Can i > break up the file automatically and send or something? > > Please help.. > > T. Edison Jr. > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Autos - Get free new car price quotes > http://autos.yahoo.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
