 |  |  |  |  |  |  |  |
uploading .txt file via phpmyadmin to Mysql
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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..
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
•
•
•
•
Originally Posted by Monte
txt file.. why would you use that, why not a .sql?
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.
Check out my blog at http://www.shinylight.com for more stuff about web dev.
•
•
•
•
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?
|
Similar Threads
- .txt file reading question (Java)
- uploading large txt file into phpmyadmin? (MySQL)
- How to import excel file data to mysql database (ASP.NET)
- uploading file using JSP to mysql database (JSP)
Other Threads in the MySQL Forum
- Previous Thread: mySQL database searching for registration
- Next Thread: MySQL newbie need help with create table definitons syntax
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency
