How can I insert large files in MySQL db using PHP?

by

You will want to check the MySQL configuration value “max_allowed_packet”, which might be set too small, preventing the INSERT (which is large itself) from happening.

Run the following from a mysql command prompt:

mysql> show variables like 'max_allowed_packet';

Make sure its large enough. For more information on this config option see

MySQL max_allowed_packet

This also impacts mysql_escape_string() and mysql_real_escape_string() in PHP limiting the size of the string creation.

More Related Contents:

  1. How can I store and retrieve images from a MySQL database using PHP?
  2. Insert Blobs in MySql databases with php
  3. I need my PHP page to show my BLOB image from mysql database
  4. displaying an image stored in a mysql blob
  5. Php : Convert a blob into an image file
  6. How to display an BLOB image stored in MySql database?
  7. php:Store image into Mysql blob, Good or bad?
  8. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  9. how to download blob based file from MySQL database in PHP?
  10. drop down menu using php and mysql [closed]
  11. php code for multiple search box after connecting to mysql [closed]
  12. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  13. Using PHP 5.5’s password_hash and password_verify function
  14. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  15. Levenshtein: MySQL + PHP
  16. PHP MySQLI Prevent SQL Injection [duplicate]
  17. mysql PDO how to bind LIKE
  18. How to test if a MySQL query was successful in modifying database table data?
  19. How do i “echo” a “Resource id #6” from a MySql response in PHP?
  20. Does mysql_real_escape_string() FULLY protect against SQL injection?
  21. How to add a delete button to a PHP form that will delete a row from a MySQL table
  22. Recursive categories with a single query?
  23. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  24. Date in a URL dd/mm/yyyy
  25. MySQL Query IN() Clause Slow on Indexed Column
  26. array_push() vs. $array[] = …. Which is fastest? [duplicate]
  27. using the browser prompt to download a file
  28. Group mysql results by category and display them into groups under each category
  29. Save array in mysql database
  30. PHP & mySQL: When exactly to use htmlentities?

Leave a Comment