0

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.

Ropali Munshi
  • 2,757
  • 4
  • 22
  • 45
user586011
  • 1,908
  • 4
  • 18
  • 29
  • an easy fix if you are on shared hosting is to split your sql file. there is loads of these and you can do it on the fly online – Talal Apr 06 '19 at 13:42
  • I rechecked php.ini, and the values are what I had set for them. I didn't stop/restart apache but am able to open phpmyadmin. It just won't upload the file. – user586011 Apr 06 '19 at 13:44
  • You *need* to restart apache – Nick Apr 08 '19 at 03:46

1 Answers1

0

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

Akio Alex
  • 316
  • 1
  • 9