•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 423,616 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,194 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.
Please support our MySQL advertiser: Programming Forums
Views: 6804 | Replies: 4
 |
•
•
Join Date: Jul 2004
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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..
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..
•
•
Join Date: May 2002
Location: Maryland
Posts: 155
Reputation:
Rep Power: 8
Solved Threads: 3
Junior Poster
txt file.. why would you use that, why not a .sql?
Microsoft Certified Desktop Support Technician
DTS Medical Webmaster + Network Administrator
Extended64.com
DTS Medical Webmaster + Network Administrator
Extended64.com
•
•
Join Date: Jul 2004
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by Monte
txt file.. why would you use that, why not a .sql?
•
•
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation:
Rep Power: 12
Solved Threads: 4
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.
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
•
•
Join Date: Jul 2004
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
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.
Does that seem like it will work?
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Password Protection from a txt.file (HTML and CSS)
- reading txt file into array (C++)
- Capturing data from txt file using JavaScript/HTML (JavaScript / DHTML / AJAX)
- How can I read from a txt file? (C++)
- URGENT - Reading from txt file into a 2 dimension array (Java)
Other Threads in the MySQL Forum
- Previous Thread: mySQL database searching for registration
- Next Thread: MySQL newbie need help with create table definitons syntax
