编辑 phpmyadmin blob 字段

2022-01-05 00:00:00 mysql phpmyadmin

嗯.

与 在 phpMyAdmin 中查看 Blob 的内容 一样,我有一个斑点.

In the same vein as Viewing Content Of Blob In phpMyAdmin, i have a blob.

就像在给定网址的屏幕截图中一样,它显示blob".谢谢,phpmyadmin!你是最棒的!

And just like in the screenshot of the given url, it says "blob". Thanks, phpmyadmin! You're the best!

不过,与提出上述问题的那个人不同,我真的很想编辑 blob 值,然后保存它们.所以,如果我的 blob 有,作为它的文本ima blob yo" - 我可以看到那个文本,感谢上面给出的解决方案 - 我如何将它编辑为我是一个 blob,你".

Unlike the chap who asked the question above, though, I really want to edit the blob values, and then save them. So, if my blob has, as its text "ima blob yo" - and I can see that text, thanks to the solution given above - how do i edit that to "i am a blob, you".

我不想在每次编辑 blob 时都上传文本文件,那太糟糕了.只是想编辑它,就像我编辑文本字段一样.

I don't particularly want to upload a text file each time i edit a blob, that's totes bogue. Just want to edit it, as i would a text field.

干杯!

推荐答案

啊.phpmyadmin 站点,有这个页面:http://www.phpmyadmin.net/documentation/#faq1_31

Ah. the phpmyadmin site, there this page: http://www.phpmyadmin.net/documentation/#faq1_31

$cfg['ProtectBinary'] boolean or string
Defines whether BLOB or BINARY columns are protected from editing when browsing a table's content. Valid values are:

    * FALSE to allow editing of all columns;
    * 'blob' to allow editing of all columns except BLOBS;
    * 'all' to disallow editing of all BINARY or BLOB columns.

好的,到此详细介绍如何允许我编辑我的 Blob.

Ok, so that details how to allow me to edit my blobs.

我做了改变

$cfg['ProtectBinary'] = FALSE;
$cfg['ShowBlob'] = TRUE;

并将这两行作为我的 config.inc.php 文件的最后几行,因为我使用的是 UBUNTU 并使用了自动安装 sudo apt-get install phpmyadmin,位于 /etc/phpmyadmin/

and put these two as the last lines in my config.inc.php file, which, because i'm using UBUNTU and used the auto install sudo apt-get install phpmyadmin, was at /etc/phpmyadmin/

一切都奏效了,有点.我现在可以编辑我的 blob... 限制是 phpmyadmin 在blob-view"中显示 blob 的当前内容,这是一大堆数字或一些废话.

And everything worked, kinda. I can now edit my blobs... with the limitation that phpmyadmin shows the current contents of the blob in "blob-view", which is a whole bunch of numbers or some nonsense.

我发现的简单解决方案是:

Simple solution i found was to:

  1. 写在文本上.简单的编辑并不是一个真正的选择,但幸运的是我不需要编辑,只需添加新数据.
  2. 将功能"选项从...更改为...我不记得它是什么,但它很疯狂...只是空白".这与其他值的函数选项默认值相同类型的空白 - 整数等

干杯,安德鲁

PS

$cfg['ShowBlob'] = TRUE;

来自我链接到的问题中的给定网址.海报指出它在 phpmyadmin 中无效,但我几个月前才使用最新的 sudo-get 下载,所以它仍然有效.实际上,我需要将该值放入其中才能进行编辑.

was from the given url in the question i linked to. The poster states it isn't effective in phpmyadmin, but i only downloaded using a latest sudo-get a few months back, so it still works. Actually, i needed to put that value in to get editing to work.

相关文章