import mysql blob data using php

Question

i am trying to save image data in mysql using blob format these are inserted and retrieved correctly using php i have a problem , i need to create a separate sql file for certain data which includes blob data when i try to import the sql file it is not able to import the blob data

include 'database.inc.php';
if (isset($_FILES['sqlfile']) && !empty($_FILES['sqlfile'])) {
$filename=$_FILES['sqlfile']['name'];
$tmp_filename=$_FILES['sqlfile']['tmp_name'];
move_uploaded_file($tmp_filename, $filename);
$file_content=file_get_contents($filename);
$commands = explode(';',trim($file_content));
foreach ($commands as $command) {
    if(mysql_query($command)){
        //header('Location: '.$_SERVER['HTTP_REFERER']);
    } else {
        //echo 'Failed to import with following command <br/>'.$command;
        echo mysql_error();
    }
}
}

Community · Accepted Answer · 2017-05-23 11:49:55Z

1

You'll have to properly encode the data in the SQL file, like in this answer to "How to insert BLOB and CLOB files in MySQL?".

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Apr 14, 2014 at 13:14

JimmyB

12.8k2 gold badges33 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

import mysql blob data using php

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related