Hi, I think I have come up with a solution for large data uploads.
I'll have the client FTP the file to a folder outside the public web root. That will get me around the file size issue. Then use a script to list the folder content. When the user clicks the link the script will test the file for .txt or .csv. The script will require user authentication. Then I use fopen, fgetcsv and addslashes. Then parse my insert query. and run the query. That is the idea anyway. I have some testing to do. I might run into a runtime timeout issue, but I'll have to think more on this. Sincerely, Mike -- Mike Brandonisio * Web Hosting Tech One Illustration * Internet Marketing tel (630) 759-9283 * e-Commerce [EMAIL PROTECTED] * http://www.jikometrix.net JIKOmetrix - Reliable web hosting On Feb 16, 2006, at 3:57 PM, Mike Brandonisio wrote: > Hi, > > I was wondering how anyone here deals with move large amounts of > mysql data to be uploaded to the server? Large as in 75MB CSV file. I > have a client who wants to admin there database with 15,000 users. > They manage all data offline and want to upload to the site for > display purposes only. My server has 5MB php file upload limit. I > really do not want to up this limit. > > What I am wondering is how does cPanel or PHP MyAdmin get around this > upload limit using php scripting? > > Sincerely, > Mike > -- > Mike Brandonisio * IT Planning & Support > Tech One Illustration * Database Applications > tel (630) 759-9283 * e-Commerce > [EMAIL PROTECTED] * www.techoneillustration.com > > > > > Community email addresses: > Post message: [email protected] > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > > Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > Yahoo! Groups Links > > > > > > > > > Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
