How would I transfer a large amount of data to a MySQL server in one value?


Problem :

I am making a PHP script which uploads a very large amount of data to a MySQL server. I do not have administrator rights for the MySQL server, so I can not change the maximum packet size, but I want to be able to transfer at least one Gigabyte of data to a single value on the server.

Because I am limited to the packet size max of the MySQL server, I am unable to transfer a large amount of data. Is there some keyword in MySQL for adding onto a value? If so, I could transfer the data in segments of the maximum amount of data the packets could be.

I have not found anything like this so far.

Is there some strategy I could use to store large (1 GB or more) amounts of data in a single MySQL value? Thanks!



Solution :

You could use the concat mysql method and UPDATE the data

UPDATE `table` SET `table`.`data` = concat(`table`.`data`, '$input') 
  WHERE `table`.`id` = $id;

Mysql Tutorials

Mysql Howto..

How to insert particular element of json data in mysql database

How to access MySQL field names while reading records

How to log all changes in a mysql table to a second one?

How can I copy a mysql input to another table?

How to sort posts with meta_key using custom mysql query in wordpress?

How to reformat dates in m/d/y with in PHP array from jqgrid post data?

How to query a MySQL database via python using peewee/mysqldb?

How sort by new date first then by passed date?

how to insert xml to mysql with php [duplicate]

How to configure MySQL to rollback when using TransactionScope?

How do I use LAST_INSERT_ID() in WebMatrix

How to optimize mysql query getting categories and subcategories

How to force foreach to display div without data available from database

How can I bind an auto incremented column value of a database table to a textbox?

How to sum cells in a column if a condition is met in another column in SQL

How do I escape reserved words used as column names? MySQL/Create Table

how to do exect match on mysql_query?

How can I retrieve information from one table to order the results of another

PHP How to save data from array to mysql using laravel 5

Where can I find MySQL source code and how could I edit it?

how to sort column by descending and match pairs on another column on mysql

How to get a part of a string from MySQL?

How do I convert a mySQL timestamp into RFC-822 using Perl?

How to convert python timestamp in mysql database to date in a SQL query

How do I set Full Text on MySQL Workbench?

How do I set the time in a MySQL timestamp?

how to return row count of mysql sub query

How do I set a full date & time sql using java, and not just the date?

How to select/count all records which happened in the last 2 hours? - MYSQL

How read few columns of a table using dbReadTable