Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

max filesize limit > 2048kb?

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

max filesize limit > 2048kb?

Postby Akim » Sun Apr 03, 2005 10:56 pm

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?
Akim
New php-forum User
New php-forum User
 
Posts: 11
Joined: Sun Mar 20, 2005 11:44 pm

Postby Alexej Kubarev » Mon Apr 04, 2005 11:46 am

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.
User avatar
Alexej Kubarev
Site Admin
Site Admin
 
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län

Postby ruturajv » Mon Apr 04, 2005 8:11 pm

why don't you zip the contents and then upload the file...
would drastically reduce the file size
User avatar
ruturajv
php-forum Super User
php-forum Super User
 
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India

Postby Alexej Kubarev » Tue Apr 05, 2005 4:01 am

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..
User avatar
Alexej Kubarev
Site Admin
Site Admin
 
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län

Postby Akim » Tue Apr 05, 2005 10:48 pm

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?
Akim
New php-forum User
New php-forum User
 
Posts: 11
Joined: Sun Mar 20, 2005 11:44 pm

Postby Alexej Kubarev » Wed Apr 06, 2005 1:32 am

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...
User avatar
Alexej Kubarev
Site Admin
Site Admin
 
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län

Postby Akim » Wed Apr 06, 2005 2:26 am

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.
Akim
New php-forum User
New php-forum User
 
Posts: 11
Joined: Sun Mar 20, 2005 11:44 pm

Postby Alexej Kubarev » Wed Apr 06, 2005 4:32 am

Linux servers: use a cron job
Windows server: use AT command (its a dos command, you can createe a very nice batch files)
User avatar
Alexej Kubarev
Site Admin
Site Admin
 
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län

Postby Akim » Sun Apr 10, 2005 10:08 pm

thank you very much! You guys are great!
Akim
New php-forum User
New php-forum User
 
Posts: 11
Joined: Sun Mar 20, 2005 11:44 pm

Postby Alexej Kubarev » Sun Apr 10, 2005 10:39 pm

We know :D just kidding :)
User avatar
Alexej Kubarev
Site Admin
Site Admin
 
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län

Postby ruturajv » Sun Apr 17, 2005 7:37 pm

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
User avatar
ruturajv
php-forum Super User
php-forum Super User
 
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.