hi,
i work on mysql database , and in one of the table i have column called id wh is int and figure which is a mediumblob. (with extension called .png)
Now i want to create a new database in new server in which i have to add some of the data from this old server.
i want to import the id and figure from old server to new one.
how will i do it?
is mysql command allow to select this id and figure and put it into a file.
and take this file across my new server and load this data?
if any one could suggest me ,it will be great.
Thank you