How do I move a database with binary content ?

Mariellef

I have moved to a more recent operating system. The staff of the hosting company did the move. They took an exact copy of the database and moved it.
Problem: the binary blob-fields used to store images, can no longer be read as photo-files => photos are in correct proportions, but are a no-show (rectangle - in the right proportions - with red cross on the upper left corner).

Atli

Hi, and welcome to TSDN!

As far as I know, using "SELECT * INTO OUTFILE" and "LOAD DATA INFILE" should backup your data and restore it correctly.

You could try this, just to see if it works. DO NOT however try this on data you don't want to lose untill you have tested it!

Expand|Select|Wrap|Line Numbers

 
/* Create backup */

SELECT * INTO OUTFILE 'backup.txt' FROM myTbl;
 
/* Truncate test table */

TRUNCATE myTbl;
 
/* Restore data */

LOAD DATA INFILE 'backup.txt';

Mariellef

Thank you for your reply, I will test this and let you know if it helped me.

Mariellef

I get the error message in php that there is a "syntax error, unexpected T_STRING in /home/.../bedrijf_test.php" on line 15
SELECT * INTO OUTFILE 'backup.txt' FROM foto_copie;

Mariellef

errormessage that access is denied for my username.
Is this way only preserved for the root ?

How do I move a database with binary content ?

re: How do I move a database with binary content ?

re: How do I move a database with binary content ?

re: How do I move a database with binary content ?

re: How do I move a database with binary content ?

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about