Solved

Howto edit BLOB field in PHPMYADMIN

Posted on 2005-06-12
4
4,529 Views
Last Modified: 2013-12-12
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
0
Comment
Question by:swiftguy
4 Comments
 
LVL 28

Expert Comment

by:gamebits
ID: 14199276
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.
0
 

Author Comment

by:swiftguy
ID: 14200298
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!)

0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 15834053
PAQed with points (400) refunded

DarthMod
Community Support Moderator
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question