CODEWITHSUNDEEP
mysqldatabase
Ami Padia
Ami Padia

Reputation: 1

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.

Upvotes: 0

Views: 117

Answers (2)

treyBake
treyBake

Reputation: 6560

Just use mysql CLI -

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

Upvotes: 1

Binal Gajjar
Binal Gajjar

Reputation: 322

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.

Upvotes: 2

Related Questions