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 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 Quote: Originally Posted by 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 Can I change the settings back for security reasons once my site is up and running? Yeh. 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. 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. 2,047mb is the maximum amount you can do, I did that for it and it has updated. Also
Quote: Originally Posted by whoo . 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. 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.
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 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 Quote: Originally Posted by 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 Can I change the settings back for security reasons once my site is up and running? Yeh. 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. 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. 2,047mb is the maximum amount you can do, I did that for it and it has updated. Also
Quote: Originally Posted by whoo . 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. 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.