Page 1 of 1

Increasing the size of import database in mysql

Posted: Thu Sep 16, 2010 12:29 pm
by amplifire
Hello everyone
I want to ask you guys, that how can i configure my WAMP or php so that my phpmyadmin can support the import of larger files.
Right now by default it is able to import only upto (Max: 2,048 KiB) of backup file.

1) I want to increase this size.

2) I found something like this on the internet

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


What does all this mean and how can i increase or decrease it.

Re: Increasing the size of import database in mysql

Posted: Thu Sep 16, 2010 12:35 pm
by Eran
For explanations on the settings, the manual is your best friend
http://php.net/manual/en/ini.core.php

In short, both post_max_size and upload_max_filesize need to be changed to the limit of what you want to upload

Re: Increasing the size of import database in mysql

Posted: Thu Sep 16, 2010 4:00 pm
by John Cartwright
If you are doing this for backup/restore purposes, I would suggest the utility Big Dump.

Re: Increasing the size of import database in mysql

Posted: Sat Sep 18, 2010 3:10 am
by kaisellgren
Or the best way:

Code: Select all

mysql > source /path/to/file.sql
If that's possible for you.