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
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
Plz help me out.
Thx in advance.
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!)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.