Re: Help needed in transfering or backing up/restoring Informix database via ODBC.

Hi Clive,
SSH nor DD is available, the majority of all tools and their subsequent
libraries have been corrupted; the database is online simply due to the
fact the chunks are located on a different drive.

Now if I could use the raw chunks from the good drive, i.e. replace the
faulty drive, install OS, re-install Informix and then access the
chunks that were created previously; that might be an option; however
I'm unable to backup anything in the /opt/informix directory; so
essential configuration files are not accessible. Last I checked (years
ago), using those previous "good" chunks isn't an option; or is it?

At present I have a replacement server, same OS, same IDS version,
virtually the same hardware online, I'm exporting all the data to SQL
files (inserts); and then I'm slowly attempting to import that data
into the new server; fortunately I had a working schema, so the
database and subsequent table structure is identical - the downside is
the .SQL files were formatted with long statements (i.e. -460 errors);
and I'm having issues with the ODBC tools crashing due to the .SQL file
sizes.

In attempt to resolve the long statement errors, I'm editing each
file, running the INSERT's and then comparing the data. This process is
consuming a monumental amount of time and the outcome is uncertain as
the tools are unpredictable.

Thanks!

Clive Eisen wrote:
can you block the server in a checkpoint and dd the chunks over scp? You
don't need a trusted relationship, just informix or root access over ssh.

Then install the same version of IDS on the same sort of hardware and bingo!

.

Relevant Pages

  • Re: Help needed in transfering or backing up/restoring Informix database via ODBC.
    ... the database is online simply due to the ... fact the chunks are located on a different drive. ... running IDS? ... virtually the same hardware online, I'm exporting all the data to SQL ...
    (comp.databases.informix)
  • Re: drawbacks of Saving documents to Sql server
    ... I have never done virus scan on them. ... Since the file is really just a binary array divided into big chunks, you can get the chunks from the database as byte arrays and use Response.BinaryWrite for the arrays. ... >> webservices application\ webforms applicatoin to sql server 2000. ...
    (microsoft.public.dotnet.framework)
  • Compound files, but not Microsofts
    ... relatively small chunks of data, ... Built-in compression and encryption on the fly would be nice, ... a database has lots of features I don't need and I am not using DB-aware ... No ads, no nags freeware: http://www.tranglos.com ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Client Server shared folder/file upload (security)
    ... I would split up the files into 64K chunks and send them in byte arrays to a web service and insert them into a staging tables in the database. ... my server code would "commit" the data in the staging tables to the production tables. ... client, so they can't see database connection and other setting. ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Problem exporting data
    ... In this dbspace i have 4 chunks of 2Gb each one. ... want to replicate this database in another disk. ... Dimitar Bachvarov begin:vcard ...
    (comp.databases.informix)
Loading