Ad:

MySQL Discussion Thread
Unsolved
Views: 10406

Jul 6th, 2004

uploading .txt file via phpmyadmin to Mysql

Expand Post »

I am having difficulty uploading text files to mysql database through phpmyadmin. Here is the feedback from the hosting company:
The problem is in the inappropriate input file format (the txt file) - there are spaces before and after the comas.
To solve the problem - strip the spaces arround the comas.
Can I do this within the webpage code?

Any feedback is appreciated..

Similar Threads

.txt file reading question in Java
uploading large txt file into phpmyadmin? in MySQL
How to import excel file data to mysql database in ASP.NET
uploading file using JSP to mysql database in JSP

bufhal

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2004

Permalink

Jul 10th, 2004

Re: uploading .txt file via phpmyadmin to Mysql

txt file.. why would you use that, why not a .sql?

Monte

Reputation Points: 50

Solved Threads: 3

Junior Poster

Offline

155 posts
since May 2002

Permalink

Jul 13th, 2004

Re: uploading .txt file via phpmyadmin to Mysql

Quote originally posted by Monte ...

txt file.. why would you use that, why not a .sql?

I am new to this-I am not sure how to do that. I will receive multiple records in Excel format and need to upload through phpmyadmin to mysql db :rolleyes:

bufhal

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2004

Permalink

Jul 13th, 2004

Re: uploading .txt file via phpmyadmin to Mysql

Keep in mind that phpMyAdmin, or any web application (like forums) that imports a file with SQL statements, usually craps out if it's bigger than 1 meg. You'll have to either split the file into smaller files or run a mysql command through the console to load up the big file.

samaru

Team Colleague

Reputation Points: 262

Solved Threads: 18

a.k.a inscissor

Offline

1,227 posts
since Feb 2002

Permalink

Jul 16th, 2004

Re: uploading .txt file via phpmyadmin to Mysql

Quote originally posted by inscissor ...

Keep in mind that phpMyAdmin, or any web application (like forums) that imports a file with SQL statements, usually craps out if it's bigger than 1 meg. You'll have to either split the file into smaller files or run a mysql command through the console to load up the big file.

Thanks for the reply. I will end up with a total of 5-600 records. To avoid this inconsuistancy with phpmyadmin, I will just "replace" the files in the db with a master, as I receive them.
Does that seem like it will work?

bufhal

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: mySQL database searching for registration

Next Thread in MySQL Forum Timeline: MySQL newbie need help with create table definitons syntax

DaniWeb Message

Cancel Changes

User Name
Password