Re: informix newbie
Thanks
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message
news:bvq981$t6qg3$3@ID-64669.news.uni-berlin.de...
> Daniel wrote:
>
> >
> > "Gorazd Hribar Rajteri'" <REMOVE_gorazdh@hotmail.com> wrote in message
> > news:FUWTb.4021$%x4.424455@news.siol.net...
> >> Hi Daniel!
> >>
> >> [SNIP]
> >> >
> >> > I was wondering if there was a way to do a complete database backup,
> > save it
> >> > to a file, and bring this file to another installation of Informix
> >> > (also
> > 9+)
> >> > and do a restore? I would like to copy all tables, objects, and data.
> >> > If possible, how would I do this?
> >> >
> >>
> >> The easiest way to do this is using dbexport utility. Dbexport will
> >> create
> > a new directory with the same name as your database's
> >> name and an ".exp" extension. Inside that directory you'll find one SQL
> > script for recreating the database and a bunch of .unl
> >> files - one for each table in your database. Dbimport utility knows how
> >> to
> > insert the data into a new database. You should be
> >> carefull with your environment settings (variables like DB_LOCALE,
> > DBMONEY, DBCENTURY,...) They should be the same at the time of
> >> database xport as at the time of database import.
> >>
> >
> > I tried running dbexport and I got the following error:
> > C:\\Database\\Informix\\bin>dbexport
> > ERROR: Could not initialize the security subsystem. Please ensure that
> > this account has the nec
> > essary privileges and ensure INFORMIXSERVER value exists in the registry
> > and environment.
> >
> > The user is and administrator of the system.
> >
> > I put down the name of what I thought the INFORMIXSERVER should be (
> > ol_mymachinename ), and tried running it again and got this message:
> >
> > C:\\Database\\Informix\\bin>dbexport
> > -23101 Unable to load locale categories.
> >
> > Where can I find what environment variables I should set?
>
> Also make sure your PATH and INFORMIXDIR are set.
>
> --
> "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
> - Coluche