Solved

Upload csv into mysql

Posted on 2011-02-20
5
283 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:greeneel
  • 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:greeneel
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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.

786 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