RE: [Info-ingres] copying a database

Hiya Fred,

Here is what I do.

Log into the server as ingres
Start a telnet or dos command window
Create a directory (make sure it has enough space for a copy of the db)
Cd to the directory
Unloaddb <db> -source=. -dest=.
Run unload.ing (unload.bat)
Edit reload.ing (reload.bat if dos) change the db name
Edit copy.in change the \nocontinue to \continue
Createdb mydb
Run reload.ing (reload.bat) > reload.log
Check the reload.log for any errors E_
Sysmod mydb
Optimizedb mydb
ckpdb +j mydb

Paul

-----Original Message-----
From: info-ingres-admin@xxxxxxxxxxxxxxx
[mailto:info-ingres-admin@xxxxxxxxxxxxxxx] On Behalf Of Fred Nurk
Sent: Tuesday, 13 December 2005 10:38 AM
To: info-ingres@xxxxxxxxxxxxxxx
Subject: [Info-ingres] copying a database

I have inherited a old Ingres database that just sits and happily chugs
along. However, I need to take a copy of the database and create a new
database with the data of the original database.

My question is simple what is the process to do this?

Thanks in advance.

_______________________________________________
Info-ingres mailing list
Info-ingres@xxxxxxxxxxxxxxx
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres


.

Relevant Pages

  • NETUTIL question
    ... The problem with that is that I'll have to change all references to the database in command procedures from MYDB to NODENAME::MYDB. ... Is there a definition I can set somewhere in Ingres which will let me continue referencing my database by its name and without the nodename? ...
    (comp.databases.ingres)
  • [Info-ingres] Ingres hires Citigroup analyst as CFO
    ... Ingres hires Citigroup analyst as CFO ... Open-source database company Ingres has hired well-known financial ... The business plan at Ingres is to charge customers only for support ...
    (comp.databases.ingres)
  • Rollforwarddb -e failure
    ... I've been running recovery tests for a contingency plan that I'm ... I've tried it so far on both my target platform (Tru64 5.1b with Ingres ... Create a database and create at least one table with some ... are any other uncommitted transactions with an earlier start time to be ...
    (comp.databases.ingres)
  • Re: How to Create a Backup Site ?
    ... My Boss ask me how to create a Backup site for Ingres Database, I looked at Ingres Documentation and the only solution that I can found was use ingres replicator to whole the database. ... The incremental rollforwarddb feature allows the journals from a database to be incrementally applied, as they are generated, to a backup copy of the database. ...
    (comp.databases.ingres)
  • Re: T-SQL CLOSE Connection to DB
    ... The 'MyDb' is still under the status RUNNABLE for the command 'SELECT ... INTO' under the ProgamName 'Microsoft SQL Server Management Studio - ... Management Studio uses the ALTER DATABASE command I ... paste the contents of the clipboard in a query window or in a ...
    (comp.databases.ms-sqlserver)