Re: [PHP] Importing CSV File : 100000 Rows!
On Wed, Jul 17, 2002 at 10:33:50PM -0700, Thomas Edison Jr. wrote: > > 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... But, if you have the mysql terminal software installed on your localhost, and your host/user combo is permitted to log in to the database, you can log in to the database from your machine. Something like: mysqlimport -h remote.host.com -u username -p databasename file.txt http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#mysqlimport Otherwise, break up the file into smaller pieces and see how that works. --Dan -- PHP classes that make web design easier SQL Solution | Layout Solution | Form Solution sqlsolution.info | layoutsolution.info | formsolution.info T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 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 <[EMAIL PROTECTED]> 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." <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 18, 2002 10:50 AM > Subject: [PHP] Importing CSV File : 10 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 10. 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 : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ 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
Re: [PHP] Importing CSV File : 100000 Rows!
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 : 10 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 10. 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
[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 10. 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