|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
February 25th, 2005, 01:57 PM
|
||||
|
||||
|
export and import BLOB's
I made a database containing some tables about movies and actors.
The movie table contains one blob field in which I have stored the poster of the movie. My colleague is collecting the information about the movies (titles, year of release). Then, I do the export from her table and import this table into my environment. There I add the poster in the blob field. This works nice and I've made a JSP which shows the poster alongside with the textual information. Unfortunately, when I used Navicat to do the export of my table (with the posters) and wanted to import this table in the database of my colleague, we got an error. Does anyone know what should be done to be able to export BLOB's from a table and import them again in the same table but on another environment ?
|
|
#2
March 12th, 2005, 03:34 AM
|
||||
|
||||
|
I've found the answer to this problem, so, in case anyone has the
same problem : I use the data transfer menu option to download the SQL instructions (containing create and insert statements). ANd this worked. Mind you, since the blobs are quite big (I even had to use longblob instead of blob), I had to copy and paste the inserts by the 10; not all at once.
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > export and import BLOB's |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
