max filesize limit > 2048kb?

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

Moderators: egami, macek, gesf

Post Reply
Akim
New php-forum User
New php-forum User
Posts: 11
Joined: Sun Mar 20, 2005 11:44 pm

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?
Kind Regards

Akim

User avatar
Alexej Kubarev
Site Admin
Site Admin
Posts: 2213
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län
Contact:

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.
Best Regards,
Alexej Kubarev
-------------------------------
Zend Certified Engineer
Image Image

User avatar
ruturajv
php-forum Super User
php-forum Super User
Posts: 1279
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India
Contact:

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

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..
Best Regards,
Alexej Kubarev
-------------------------------
Zend Certified Engineer
Image Image

Akim
New php-forum User
New php-forum User
Posts: 11
Joined: Sun Mar 20, 2005 11:44 pm

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?
Kind Regards

Akim

User avatar
Alexej Kubarev
Site Admin
Site Admin
Posts: 2213
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län
Contact:

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...
Best Regards,
Alexej Kubarev
-------------------------------
Zend Certified Engineer
Image Image

Akim
New php-forum User
New php-forum User
Posts: 11
Joined: Sun Mar 20, 2005 11:44 pm

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.
Kind Regards

Akim

User avatar
Alexej Kubarev
Site Admin
Site Admin
Posts: 2213
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län
Contact:

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)
Best Regards,
Alexej Kubarev
-------------------------------
Zend Certified Engineer
Image Image

Akim
New php-forum User
New php-forum User
Posts: 11
Joined: Sun Mar 20, 2005 11:44 pm

Sun Apr 10, 2005 10:08 pm

thank you very much! You guys are great!
Kind Regards

Akim

User avatar
Alexej Kubarev
Site Admin
Site Admin
Posts: 2213
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län
Contact:

Sun Apr 10, 2005 10:39 pm

We know :D just kidding :)
Best Regards,
Alexej Kubarev
-------------------------------
Zend Certified Engineer
Image Image

User avatar
ruturajv
php-forum Super User
php-forum Super User
Posts: 1279
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India
Contact:

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

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 0 guests