0

I need to import a database but a warning is displayed as below

error phpmyadmin.POST Content-Length of 3617 bytes exceeds the limit of 128 bytes in Unknown on line 0

Frits
  • 7,341
  • 10
  • 42
  • 60
Aswathy
  • 211
  • 2
  • 9
  • 1
    Possible duplicate of [Can't import database through phpmyadmin file size too large](https://stackoverflow.com/questions/9593128/cant-import-database-through-phpmyadmin-file-size-too-large) – Thomas G Jun 12 '17 at 09:29
  • You can import database via terminal like this :- mysql -u -p < – Nithin John Jun 12 '17 at 09:32
  • I suggest that you change the `post_max_size` to 16M in the `php.ini` file, restart the Apache and try again. – Milan Chheda Jun 12 '17 at 13:15

2 Answers2

0

Here's what you can do

  1. Go to XAMPP installed directoy C:\xampp\php
  2. Open the "Configuration Settings" file named php.ini using your text editor.
  3. Update upload_max_filesize = 128M
  4. Similarly update post_max_size = 128M
  5. Then max_execution_time = 200
  6. And max_input_time = 200
  7. Restart XAMPP to see the changes
Ndroid21
  • 400
  • 1
  • 8
  • 19
0

try to import command line ,by using this command

mysql -u mysql_user -p DATABASE < backup.sql
Robert
  • 3,373
  • 1
  • 18
  • 34