RE: informix newbie

Daniel, I assume that you are running in Eindows. When you create a database in windows the system creates an Informix account. User Informix, with the same password. Log in as that user and then run program ol_mymachinename from the Windows RUN menu. That should give you access. And with all the correct environment variables set. Regards Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Daniel Sent: 04 February 2004 04:03 To: informix-list@iiug.org Subject: Re: informix newbie "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? > > For each database, where does Informix keep the file? I have my installation > > in c:\\Database\\Informix. > > > > I have no idea for Windows... We always used raw devices (unformatted > disk partitions). > > > I am trying the Server Studio GUI program. Is there an easy way to insert > > via a gui? Something akin to SQL Server's Enterprise Manager, where > > it's Excel-like with boxes you can fill data with? If I missed in > > Server Side, > > perhaps you can point me out to its functionality. > > > > Any other good GUIs for Informix? > > > > ServerStudio is a good start. You could also try WinSQL (http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp). > > Gorazd > sending to informix-list