Announcement

Collapse
No announcement yet.

How can I Increase the File upload size in phpmyadmin?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How can I Increase the File upload size in phpmyadmin?

    Hi All

    Can anyone tell me what I need to do to increase the file upload size in phpmyadmin? At the moment it is set to: Max: 2,048KB

    I need to restore a database that is about 80meg.

    Thanks in advance.
    Don't Forget To Say Thanks
    Don't Let The Post DIE ... REPLY !!

  • #2
    Originally posted by singh9211 View Post
    Hi All

    Can anyone tell me what I need to do to increase the file upload size in phpmyadmin? At the moment it is set to: Max: 2,048KB

    I need to restore a database that is about 80meg.

    Thanks in advance.


    80megs needs to be done via the command line. I have three sites that have over 100meg databases and I wouldn't even think about putting them through phpmyadmin. Would take a lot longer to do anyway that way since it also have to go through PHP as well now. On the command line, they get inputted within a few seconds.

    mysql - u username -p databasename < filename.sql

    where:

    username is the name of the MySQL user
    databasename is the name of the database that you are importing into
    filename.sql is the name of the backup database file.

    If you really feel the need to change this setting though, try changing the upload_max_filesize setting within your php.ini file. I believe you need to restart Apache once you make these changes. I'd also change the max_execution_time as well since it's going to take longer than 30 seconds for your file to be processed.

    Hope this helps,
    eLLuSiOnIsT

    Comment

    Working...
    X