mysql blobs
Hello, I tried dumping my innodb tables that contain blobs. No errors are returned from mysqldump but I cannot restore the blob data. I have used the below mysqldump statement. mysqldump --opt --add-drop-table --force --single-transaction -uxxx -pxxx --databases myDB bakupFile I restore the backupFile with mysql -uxxx -pxxx backupFile Everything is included in the restured database except the blob data. When I look in backup file I can see that all my blod data has been replaced by -. What causes this? Regards /Jonas
Howto: insert PHP code into mysql blobs
Just a noob question... (I suppose)
When I try just putting php code in my insert query, it goes like this:
insert into mytable values('?php echo some string; ?')
select * from mytable, returns:
?php echo some string; ?Some string
Any help would be greatly appreciated!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Howto: insert PHP code into mysql blobs
Just a noob question... (I suppose)
When I try just putting php code in my insert query, it goes like this:
insert into mytable values('?php echo some string; ?')
select * from mytable, returns:
?php echo some string; ?Some string
Any help would be greatly appreciated!
I think if you write php code in to text file (or php script) such as
mycode.txt and then use
insert into mytable values (load_file('/path/path/mycode.txt'));
it must be simple done.
Kittiphum Worachat,M.T.
www.hatyailab.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
