Re: 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