phpmyadmin Question posted in
The official documentation can be found here.

I can't import the database throgh PHPMyAdmin

I am trying to import database through PHPMyAdmin. My database file is abc.sql and it’s size is 50.9 MB. I am trying this on local and it’s saying:

You probably tried to upload a file that is too large. Please refer to documentation for ways to workaround this limit.

Please Help with this.

Tags:

2

Answers


  1. 0

    Just use mysql CLI –

    1) Command Prompt
    2) mysql -uusername -p (enter password when prompted)
    3) use database_name
    4) source C:pathtofile.sql

    Login or Signup to reply.
  2. 0

    You can update the maximum upload size from php.ini file.

    In the php.ini you need to update the 3 values as per your requirement

    • upload_max_filesize
    • post_max_size
    • memory_limit

    Then restart your apache server. You will able to import the database.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search