Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Upload csv into mysql

Posted on 2011-02-20
5
Medium Priority
?
298 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 2000 total points
ID: 34940900
0

Featured Post

Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

Question has a verified solution.

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

Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses

721 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