Re: DBEXPORT/DBIMPORT

kimberley@furkon.com wrote: > I am new to the informix world and have come across a problem. I'm using > Informix 7.X SE and wrote a cron job to backup the database. I accidentally > used the line: > > dbxport -d foo > > instead of > > dbxport foo > > I believe I now have an OL backup. When I try to import the database I get an > error informix.sysblobs is not in the database. Is there any way I can convert > my OL backup to import it into a SE database. > > Thanks in advance, > Matt > If it was only that easy to convert from SE to Online:-) It is not an OL database. I suspect that the top of the SQL file genereated by the export now 'as if by magic' has some blob stuff near the top. I can't remember what it is - all you need to do is remove this from the file and then the export will work. If the export is on tape you'll have to 'dd' it in and then correct it. I have a script around somewhere that can process this file. -- Paul Watson # WF Software Ltd # If it ain't broke, Tel: +44 1436 674729 # fix it till it is. Fax: +44 1436 678693 # www.wfsoftware.co.uk #