?
Solved

export a blob field

Posted on 2010-11-08
3
Medium Priority
?
500 Views
Last Modified: 2012-08-13
I am trying to export a table from a mysql database.  The table includes a blob field and why i export using sql or directly to ms access the blob field which contains a long description does not copy across.

Can anyone tell me how to do this?
0
Comment
Question by:Nemetona
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
Shinesh Premrajan earned 2000 total points
ID: 34083424
mysqldump -uuser -ppass db dbname > exported.sql

hope this helps
0
 

Author Comment

by:Nemetona
ID: 34083607
Thank you shinug, that seems to do what I want.  If you don't mind I have a follow up question - the syntax for importing the exported.sql file (or at least one of the tables in it) into a different database with the same structure.
0
 
LVL 17

Expert Comment

by:Shinesh Premrajan
ID: 34083745
mysqlimport -uuser -ppass --replace --fields-terminated-by=';' dbname /path/to/db/file/to/import

Hope this helps


0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question