.txt Data Import to MySQL?

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

.txt Data Import to MySQL?

Postby Kaththea » 18. February 2006 00:02

When I try to import a .txt file into my MySQL table it will only import the first set of data. It won't go on and fill the next row of fields. Am I missing something at the end of the first line of data in my .txt file that's stopping it?

Help please? :(
Kaththea
 
Posts: 3
Joined: 30. November 2005 22:09

Re: .txt Data Import to MySQL?

Postby elena » 22. April 2006 15:24

Kaththea wrote:When I try to import a .txt file into my MySQL table it will only import the first set of data. It won't go on and fill the next row of fields. Am I missing something at the end of the first line of data in my .txt file that's stopping it?

Help please? :(



are you using the php admin? check what the wizard says about end-line character for the file you are importing
elena
 
Posts: 3
Joined: 23. February 2006 08:10

Postby capitalfellow » 23. April 2006 15:12

When asking for you help please post the exact commands or steps you are following to achieve the task. They are often mutliple ways of achieving the same goal and telling us what method you are using saves us a step.
User avatar
capitalfellow
 
Posts: 60
Joined: 19. July 2005 01:10
Location: Charlotte, NC USA
XAMPP Version: 5.5.19
Operating System: OS X


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 6 guests