max filesize limit > 2048kb?

[Akim]

Hi!

When I look at the import textfile screen it says that the max filesize is 2048kb. What if I like to import larger files?

[Alexej Kubarev]

it is due to your php.ini limitations... change the max file upload size to something more and you will be able to upload bigger files.

[ruturajv]

why don't you zip the contents and then upload the file...
would drastically reduce the file size

[Alexej Kubarev]

well... think if the zip file will still be over 2Mb?
however ziping the file is a good solution too... i would, however like to see RAR functions as i like rar files much more..

[Akim]

I changed the entry in php.ini from 2M to 100M. Now PHPmyAdmin shows me a max filesize of 8.192KB, which is of course far better than 2.048KB but still not satisfying. I'll get data files which will be several MB large, even zipped more than 8MB. Because today mySQL is discussed as a real alternative to commercial databases it should easily handle that amount of data, shouldn't it?

[Alexej Kubarev]

yes..however phpMyAdmin is not a mySQL developed solution for importing data.. if you want to import data throught a MySQL developed solutions:

use MySQL Administrator for importing SQL files,
use MySQL Query Browser for excecuting, queries..

Those work perfectly fine and i, honestly sid, prefere using them and not phpMyadmin.

Those 2 programs are working independant from PHP and therefore there is no limitations on file sizes...

[Akim]

thanx for the advice. Is there also a script based way to import files into mySQL db automatically? Something like this:

Import from Folder Y:\someNetworkFolder\someFile.csv every night at 3:00 AM data into table myTable in database myDatabase.

[Alexej Kubarev]

Linux servers: use a cron job
Windows server: use AT command (its a dos command, you can createe a very nice batch files)

[Akim]

thank you very much! You guys are great!

[Alexej Kubarev]

We know just kidding

[ruturajv]

you can directly import stuff as huge file size that the kernel can support...
if you have to the mysql command line client
you can do ...

Code: Select all

$mysql -u root -p db_name < /path/to/script.sql