MySQL PHP Data Import greater 8MB

Hello I woud like 80MB over PHP uploaden? Change the PHP.ini but i have time import Problem. Who can my help? Thanks

Replies (6)

Solution

Reply 1 2010-08-29

Hi,

You need to edit both php.ini and my.cnf.
Then restart PHP and MySQL (or reboot).

If your dump file is really big, use this:
http://www.ozerov.de/bigdump.php

Regards,
Anne

Thanks i'm upload 100MB, wich

Reply 2 2010-08-29

Thanks i'm upload 100MB, wich konfig are php.ini and my.cnf?

Can you Post the change from 8MB to 100MB?

Thanks M

Good work Anne!

Reply 3 2010-08-30

But FYI sudo is not required in TKL appliances as default user account is root (although all processes run under limited accounts).

Solution

Reply 4 2010-08-29

Edit with vi or nano. Don't forget to sudo. But remember, these settings are not recommended for daily use (potential security risk)...

In php.ini:

; Maximum allowed size for uploaded files.
; http:// php.net/upload-max-filesize
upload_max_filesize = 2M

Also in php.ini:

; Maximum size of POST data that PHP will accept.

; http:// php.net/post-max-size

post_max_size = 8M

In my.cnf:

[mysqldump]
quick
max_allowed_packet=32M

The bold numbers are default.

Thanks for you special

Reply 5 2010-09-01

Thanks for you special support!

We'll look into changing the defaults

Reply 6 2010-09-21

Perhaps 8MB is too small a size for the default upload limit. I'm thinking maybe we should ramp it up to 32MB. The flip side is that I think larger upload limits make DoS (Denial of Service) attacks easier. OTOH, DoS is impossible to stop entirely anyhow.