Uly.me

cloud engineer

  • Home
  • About
  • Archives
Home/PHP/Editing a Blob in PHPMyAdmin

March 1, 2016

Editing a Blob in PHPMyAdmin

One of my projects this week requires editing a blob. A blob is a binary large object used primarily for storing images, audio and other media types in the database. Unfortunately, the application didn’t allow me to edit a blob. So off to the PHPMyAdmin I went. PHPMyAdmin is a MySQL administration tool.

By default, the blob entries in PHPMyAdmin can’t be edited. Simple texts in blobs are sometimes scrambled. In order to make changes to the blob entries, we need to reconfigure PHPMyAdmin by editing the configuration file.

Edit the /etc/phpmyadmin/config.inc.php file.

$ sudo nano /etc/phpmyadmin/config.inc.php

$ sudo nano /etc/phpmyadmin/config.inc.php

Add the following entries at the end of the file.

$cfg['ProtectBinary'] = FALSE;
$cfg['DisplayBinaryAsHex'] = FALSE;
$cfg['ShowBlob'] = TRUE;

$cfg['ProtectBinary'] = FALSE; $cfg['DisplayBinaryAsHex'] = FALSE; $cfg['ShowBlob'] = TRUE;

There is no need to restart any services. Changes are automatically reflected in PHPMyAdmin.

Filed Under: PHP Tagged With: blob, phpmyadmin

Sign up

Get content delivered to your mail!

About Me

I'm Ulysses, a Cloud Engineer at Cardinal Health based in Columbus, Ohio. I’m a certified AWS Solutions Architect. This website is my way of documenting the things I've learned about the Cloud. When off the grid, I enjoy riding my electric skateboard. I've surfed, snowboarded and played saxophone in the past. I hope you find this site helpful. It's powered by WordPress and hosted in AWS.

  • Cloud
  • Linux
  • Git

Copyright © 2012–2021