table import

[matrixknow]

Hi,

MySql limits the size of the records that you can import in one time. I have a large table coming from MS Access and I like (need) to import this in MySQL to work afterwards with this. What are the different ways to import in one time a large table. This MySQL database is my backend for a php driven website.

A conversion to a csv file first ?

 

[guelphdad]

I don't believe mysql restricts the size of the file. are you using phpmyadmin or anything like that? Most likely that is the culprit.

 

[matrixknow]

yes, I use phpMyAdmin. Are there others way to import large amount of data ?

 

[guelphdad]

look into the use of LOAD DATA LOCAL INFILE

 

[Kozusnik]

Or modify your php.ini file to allow larger file sizes. Once you stop and restart apache, phpmyadmin will show the new size.

upload_max_filesize = 2M
change to ...
upload_max_filesize = 500M

You may need to fool with some of the other settings also so the script doesn't time out.
Mark