Link to home
Start Free TrialLog in
Avatar of swiftguy
swiftguy

asked on

Howto edit BLOB field in PHPMYADMIN

Hello All,

I have a table having Blob datatype having more than 1000 records. I use Phpmyadmin for mysql maintenance.

Phpmyadmin does not display or edit  columns of Blob datatypes? Now i have to edit a blob field how do i do that in phpmyadmin?

i thought changing columns of 'blob'  datatype to text or char would atleast help me in browsing/editing the data .....but was unable to change datatypes :(

following was the error when i tried to change blob datatype to char datatype

(mysql#) alter table electrical change address address text character set utf8;

ERROR 3 (HY000): Error writing file './property/#sql-b0d_5.frm' (Errcode: 28)

Plz help me out.

Thx in advance.

Swiftguy
Avatar of gamebits
gamebits
Flag of Canada image

What kind of data do you have in blob field?

What if you do a backup copy of your database, structure and data, this should give you a text file, then edit the text file and reload to the db. Use the export tab.
Avatar of swiftguy
swiftguy

ASKER

Thx  for responding gamebits!

I sorted out the problem ...its rather a simple solution ..... I just changed the data type from Blob to text in the phpmyadmin interface..
(when i tried to change from MySQL shell i faced problem but same datatye change from PHPMyAdmin worked flawlessly!)

ASKER CERTIFIED SOLUTION
Avatar of DarthMod
DarthMod
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial