Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does BLOB streaming work in phpMyAdmin?

blob phpMyAdmin streaming
0
Posted

How does BLOB streaming work in phpMyAdmin?

0

First, for general information about BLOB streaming on MySQL, visit blobstreaming.org. We currently support streaming if you are running MySQL 5.1 with the PBXT and PBMS storage engines. • 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 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 yo

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123