uploading large txt file into phpmyadmin?
 

I want to transfer a large text file (a database of over 1000 users) into phpmyadmin? How do you recommend I do this most efficiently? do I have to go through each user individually placing the appropriate quotations and punctuation? or is there an easier method?

Thanks!

Re: uploading large txt file into phpmyadmin?
 

Instead of using PHPmyAdmin i would suggest you to use PHP to open the file and read the test file and write a sql query that would go around in a loop until the end of file.
This is the fastest way of doing it , if the text file you are talking about is not an sql dump or export from phpmyadmin.

If the text file is a dump or export of an sql database then i would suggest you to use the import feature provided in phpmyadmin