In php.ini I have set php to allow 7MB POST data size. But when I used phpmyadmin to save 1MB data of text into a field, it just listed all the record from the parent table and did nothing to the record which supposed to be changed after I pressed the "save" button.

Is this a limit of phpmyadmin? What can I do to solve the problem?

  • Is the field of type LONGTEXT? Anything less and MySQL would not store it.
    – milo5b
    Jul 6, 2012 at 15:27
  • You also might just be running into an execution timeout. That's a lot of data to send all at once and the server could just be killing the process.
    – Su'
    Jul 7, 2012 at 3:27

1 Answer 1


These are the MySQL text field size limits

TINYTEXT 256 bytes

TEXT 65,535 bytes ~64kb

MEDIUMTEXT 16,777,215 bytes ~16MB

LONGTEXT 4,294,967,295 bytes ~4GB

  • I don't really know whether this is the correct answer or not. I ended up saving the query into a file and used SOURCE command from the command line to update the field for me, instead of using phpmyadmin. Anyway, thanks for that information.
    – herophuong
    Jul 7, 2012 at 3:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.