How would I transfer a large amount of data to a MySQL server in one value?
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!
You could use the concat mysql method and UPDATE the data
UPDATE `table` SET `table`.`data` = concat(`table`.`data`, '$input') WHERE `table`.`id` = $id;
- A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
- MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
- MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]