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.
Increasing the size of import database in mysql
Moderator: General Moderators
Re: Increasing the size of import database in mysql
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
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
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: Increasing the size of import database in mysql
If you are doing this for backup/restore purposes, I would suggest the utility Big Dump.
- kaisellgren
- DevNet Resident
- Posts: 1675
- Joined: Sat Jan 07, 2006 5:52 am
- Location: Lahti, Finland.
Re: Increasing the size of import database in mysql
Or the best way:
If that's possible for you.
Code: Select all
mysql > source /path/to/file.sql