Solved

Upload csv into mysql

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

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.
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This video teaches users how to migrate an existing Wordpress website to a new domain.

828 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