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!
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.