Jump to content
  • 0

SQL import exceeded max file size


Dolphin86

Question


  • Group:  Members
  • Topic Count:  253
  • Topics Per Day:  0.06
  • Content Count:  701
  • Reputation:   16
  • Joined:  01/07/12
  • Last Seen:  

as title i was trying to upload my backup sql to phpmyadmin, got this error

 No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

i did some google and it state i need to edit php.ini to max the file size, but where is the php.ini file?

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  248
  • Reputation:   34
  • Joined:  11/19/11
  • Last Seen:  

4 hours ago, dolphincute said:

as title i was trying to upload my backup sql to phpmyadmin, got this error


 No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

i did some google and it state i need to edit php.ini to max the file size, but where is the php.ini file?

Go to var/lib/phpMyAdmin/upload/    upload your .sql files to that location and then go to phpmyadmin import.

123.png.fa8628410abe9d2015d8d37f339fca74.png

Edited by shatowolf
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  308
  • Reputation:   24
  • Joined:  11/26/12
  • Last Seen:  

You just edit you PHP.INI the uploadmax from 2M to what size you want using VI or NANO...

then restart your HTTP server or your server and walah! ^_^

Edited by chatterboy
Link to comment
Share on other sites

×
×
  • Create New...