Increasing the size of import database in mysql

Discussions of secure PHP coding. Security in software is important, so don't be afraid to ask. And when answering: be anal. Nitpick. No security vulnerability is too small.

Moderator: General Moderators

Post Reply
amplifire
Forum Newbie
Posts: 23
Joined: Thu Jul 22, 2010 1:09 am
Location: India
Contact:

Increasing the size of import database in mysql

Post 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.
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Increasing the size of import database in mysql

Post 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
User avatar
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

Post by John Cartwright »

If you are doing this for backup/restore purposes, I would suggest the utility Big Dump.
User avatar
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

Post by kaisellgren »

Or the best way:

Code: Select all

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