By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

how to import csv file to mysql database file size more than 440MB

P: 1
how to import csv file to mysql database file size more than 440MB


i have a file in text format that need to be import to the database i can easily upload if the file size is less than 2MB.the same file orginal is 440MB so how can i import it and how to increase the capacity of my mysql server.
Aug 21 '11 #1
Share this Question
Share on Google+
1 Reply


mwasif
Expert 100+
P: 801
2MB limitation seems to be of PHP (phpMyAdmin). You can increase upload limit in PHP by changing values of upload_max_filesize and post_max_size. Or you can use MySQL command line client to import CSV file.
Aug 24 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.