PHPMyAdmin上传错误'文件太大'[重复]

Question

This question already has an answer here:

• How to import large sql file in phpmyadmin 18 answers

I have just set up a droplet on Digital Ocean and am trying to import a SQL database that is 68 MB via PHPMyAdmin.

I've already increased the below on php.ini to 100x their default values...

memorylimit
postmaxsize
uploadmaxfilesize

The error I get is,

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

However, the link to documentation doesn't go anywhere.

Any tips or suggestions to troubleshoot?

I imagine this is a fairly common problem, but everything I can find just refers to php.ini. Any help would be helpful.

</div>

Answer 1

Try this:

Go to sql file folder. And open cmd console.

And type "type xxx.sql | mysql -u user -p db_name"

Ex: type 1.sql | mysql -u root -p task_db

And don't use powershell. Must use CMD.

If unknown 'mysql', Add system enivoriment mysql/bin path