max filesize limit > 2048kb?
Moderators: egami, macek, gesf
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
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?
Kind Regards
Akim
Akim
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
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...
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...
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.
Import from Folder Y:\someNetworkFolder\someFile.csv every night at 3:00 AM data into table myTable in database myDatabase.
Kind Regards
Akim
Akim
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
- ruturajv
- php-forum Super User
- Posts: 1279
- Joined: Sat Mar 22, 2003 9:42 am
- Location: Mumbai, India
- Contact:
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 ...
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