Mi situación es la siguiente, tengo 2 bases de datos MySQL alojadas en dos servidores, en estas bases tengo un campo blob, Como mediante php leo o obtengo el contenido de un campo blob y lo inserto en otra tabla que tiene el mismo campo blob?
Realizo la consulta al campo
Código SQL:
Ver original
SELECT campoBlob FROM base WHERE id = 1;
y obtengo:
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| campoBlob |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| xM���UE�ፀ"�����/ !
�"���x�'�o��d}�]]�jUu�}�ٶm{xv�mW����o�{����4�l�GW����3�?�._ޮ��ٻ�7� �N�N�
~�ǟfd{8�m����t�OF�s ��>�{6����;��1�k�^�9�=��q�4����]���`���3��b�M����r��n��r�i����������8`[;N3����n�����
�[y�i���C=oOߌ���Vyq�����+��;^�mF�
�V�5�:��z�ƞ>gֹT�8�t�����rǎ�Zw�^�jaW�ygO �Gk�|�X�[w��;�w ������
����1r#Nnk#m�W}�'��;����H3ߴ���[G����͏�T�9^k0/w�q�ߺ�������{������%=��)c���A\gj]���[�_k��A�ޥ�8�t����f�7��[Gh�x>{�����<l=| �F���ż� mrx�ڣ��/nl����4ʍ�~�4~z�����déj8֏�z
�qŁ_̑��c�a�߾�����(�3���<S�O��;��1_�❕3s��-��;D��-��k]4���������@N=�v�)�Q#]kй��/8kw��ؼg�s��8����c_
���l8ę����μ����s�LJ��h�@� '?ܝ�:ʉ��ۻ�s��~��G��OzƮ�?
����`ψ�=�ýϦ4��;�v��sF��Oc�Ϩ><8���X��k1 t��s �h�C��W�8>�]��j��}1�w������l�#� ��8:��\j�N���p����p�1�{F�:K��.����E#�����_�y��p� ��#���:p��7���>���o�O�}�x��35��_��Ϝ�1�+ � |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0,00 sec)
Realice esta consulta para obtener el tamaño
Código SQL:
+------------------------+Ver original
SELECT OCTET_LENGTH(campoBlob) FROM base WHERE id = 1;;
| OCTET_LENGTH(tracebuf) |
+------------------------+
| 1212 |
+------------------------+
1 row in set (0,10 sec)