Solved

Howto edit BLOB field in PHPMYADMIN

Posted on 2005-06-12
4,445 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
Good Question?
0
Question by:swiftguy
    10,423 Solutions
    Best Solution byDarthMod
    PAQed with points (400) refunded DarthMod Community Support Moderator
    3 Comments
     
    1,073 Solutions

    Expert Comment

    by:gamebits
    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.
    Good Comment?
    0
     

    Author Comment

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

    Good Comment?
    0
     
    10,423 Solutions

    Accepted Solution

    by:
    PAQed with points (400) refunded

    DarthMod
    Community Support Moderator
    Good Solution?
    0

    Add a Comment

    Join our community to follow up on this question and 4 million more solutions.

    Join & Write a Comment

    Featured Post

    Course: AWS Professional Certification

    These classes are designed to help you pass the AWS Certified Solutions Architect – Associate, AWS Certified Developer, and AWS Certified SysOps Administrator Associate exams—all essential to a career as an AWS professional.

    Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
    Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
    The viewer will learn how to count occurrences of each item in an array.
    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.

    805 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now