Increasing size limit for importing on phpmyadmin

[Webmin]

By default the size limit for importing a database in phpmyadmin is 50mb.

How can I increase this? I have ssh access, full root.

I need to increase it to at least 900mb, how can I do this?

Thanks

Webmin Reviewed by Webmin on 2nd Apr 2012. Increasing size limit for importing on phpmyadmin By default the size limit for importing a database in phpmyadmin is 50mb. How can I increase this? I have ssh access, full root. I need to increase it to at least 900mb, how can I do this? Thanks Rating: 5

[RT]

Start using google mate, everything is there.

/etc/php.ini

Or here:

/etc/php/php.ini
/etc/php5/php.ini

Or here:

/usr/bin/php5/bin/php.ini

Anyway, you can always find any file named php.ini in this manner

find / -name php.ini

Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

[Webmin]

Start using google mate, everything is there.

/etc/php.ini

Or here:

/etc/php/php.ini
/etc/php5/php.ini

Or here:

/usr/bin/php5/bin/php.ini

Anyway, you can always find any file named php.ini in this manner

find / -name php.ini

Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Can I change the settings back for security reasons once my site is up and running?

[RT]

Yeh.

[Whoo]

I would suggest logging in via SSH to restore the database, it will be much much faster. If you don't have SSH access then have a look at Bigdump.

[Long]

Damn RT, beat me too it...

Good investigoogling though!
---

On a side not, I wouldn't increase it to 900mb lol, that's pretty crazy dude.

Just upload the sql file and do the import via SSH.

[Webmin]

2,047mb is the maximum amount you can do, I did that for it and it has updated. Also

.

I did it through ssh and got the .sql file, I made a thread about how I couldn't access ftp or sftp as root, so I have decided to do it this way since no-one could help me fix the issue.

[WDF]

You could use mysqldumper through http for the user interface/CP and ftp to transfer the files. I use it regularly to back up my 3 plus gb database. It will do backups and restores, I have not used bigdump since I found this.

You can find it by using your favorite search engine.