uploading large txt file into phpmyadmin?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 401,670 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,487 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Thread Tools Display Modes

Views: 568 | Replies: 1

•

Join Date: Mar 2008

Posts: 85

Reputation: justinmyoung is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

justinmyoung justinmyoung is offline

Offline

Junior Poster in Training

uploading large txt file into phpmyadmin?

Apr 18th, 2008

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!

•

Join Date: Feb 2006

Posts: 47

Reputation: ultra vires is an unknown quantity at this point

Rep Power: 3

Solved Threads: 5

ultra vires ultra vires is offline

Offline

Light Poster

Re: uploading large txt file into phpmyadmin?

Apr 19th, 2008

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