Solved

Upload csv into mysql

Posted on 2011-02-20
5
276 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
The viewer will learn how to count occurrences of each item in an array.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now