From e6ddf2e087f042d4309c457eec6b45954633bd5a Mon Sep 17 00:00:00 2001 From: Marc Delisle Date: Tue, 24 Mar 2009 16:36:32 +0000 Subject: [PATCH] BLOB streaming clarification --- Documentation.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Documentation.html b/Documentation.html index a22cff79e7..dea0ae24b2 100644 --- a/Documentation.html +++ b/Documentation.html @@ -4051,7 +4051,7 @@ chmod o+rwx tmp
  • In config.inc.php your host should be defined with a FQDN (fully qualified domain name) instead of something like "localhost".
  • A current limitation is that your first login via phpMyAdmin to a freshly-started server must be done with an account that has the SUPER privilege.
  • On your target database, go to Operations and in the "BLOB Repository" section, click "Enable". This creates the PBMS system tables inside your database.
    • -
  • Ensure that your target table has a LONGBLOB column.
    • +
  • Ensure that your target table is under the PBXT storage engine and has a LONGBLOB column.
  • When you insert or update a row in this table, put a checkmark on the "Upload to BLOB repository" optional choice; otherwise, the upload will be done directly in your column instead of the repository.
  • Finally when you browse your table, you'll see in your column a link to stream your data, for example "View image". A header containing the correct MIME-type will be sent to your browser; this MIME-type was stored at upload time but in case it's incorrect, it's possible to edit it by clicking on the displayed MIME-type.
    • -- 2.11.4.GIT