[rani]

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

[Nick]

one alternative to your problem is to download phpMyAdmin and do a database dumb containing only the table structure of the database and/or the data and the tables.

When it dumps, it creates a text file filled with pure MySQL commands that can be used by phpMyAdmin to easily insert the data into the new database.