Solved

Upload csv into mysql

Posted on 2011-02-20
5
290 Views
Last Modified: 2012-05-11
I'm trying to upload a file.csv into Mysql and i'm encountering the following problem:
When i first tried it stated that the file was too large and i needed to change the max upload size in the php.ini file.. I did that changed it to 10MB and restarted Apache but now
while using phpMyadmin i only see (Max: 8,192KiB) ..  

The file i'm trying to upload is alittle over 9MB.

any advice would be appreciated..
0
Comment
Question by:Eaddy Barnes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 27

Expert Comment

by:Lukasz Chmielewski
ID: 34937369
Where is that 8,192 seen ? I understand the upload is still not possible ?
Did you try changing php.ini to more than 10mb ?
0
 
LVL 5

Expert Comment

by:onemadeye
ID: 34937392
Yes, if you have access to php.ini then why dont you try to change the max upload size to more than 10MB (20MB or 30MB maybe) and let know if the problem still occur...
0
 
LVL 5

Expert Comment

by:onemadeye
ID: 34937397
If you adjust to 20MB then you will see (Max: 16,384 KiB) on phpMyadmin.
0
 
LVL 11

Author Comment

by:Eaddy Barnes
ID: 34939662
Guys, i changed it to 30MB actually, and still see the (Max: 8,192KiB) i see this in phpmyadmin on the page that comes up when u click import.
0
 
LVL 27

Accepted Solution

by:
Lukasz Chmielewski earned 500 total points
ID: 34940900
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question