Re: Importing CSV File : 100000 Rows!

Hi, Basically the problem is that i have to connect from my localhost to my MySQL database on the server/internet. I don't have command prompt access to the internet database... --- Pradeep Dsouza <php@aspbytecreations.com> wrote: > > there is a way to do it from the prompt > > I use Windows but the command on Linux is close > > if the file is called mydata.sql > > mysql > \. C:\mydata.sql > > > Hope this works > > Pradeep > > > ----- Original Message ----- > From: "Thomas Edison Jr." <thomasedisonjr@yahoo.com> > To: <php-general@lists.php.net> > Sent: Thursday, July 18, 2002 10:50 AM > 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 > > > ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastech@yahoo.com Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com