Solved

Howto edit BLOB field in PHPMYADMIN

Posted on 2005-06-12
4,458 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
Question by:swiftguy
    3 Comments
     
    LVL 28

    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.
    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!)

    0
     
    LVL 1

    Accepted Solution

    by:
    PAQed with points (400) refunded

    DarthMod
    Community Support Moderator
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Title # Comments Views Activity
    Laravel format Error 4 21
    Woocommerce - web hook for paypal payment received 2 31
    php problem? 5 24
    Problem to go to page 12 33
    This is a general how to create your own custom plugin system for your PHP application that you designed (or wish to extend a third party program to have plugin functionality that doesn't have it yet).  This is not how to make plugins for existing s…
    A colleague recently asked me about how to give his client a small part of the web site that could be completely under the client's control.  Since I have done this sort of thing before to add emergency banners to a web site, I decided I would creat…
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    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.

    690 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

    24 Experts available now in Live!

    Get 1:1 Help Now