Selasa, 15 Januari 2008

Onunload dan Onload (informix)

This tutorial show you how to move table from one machine to another machine
1. create file that informix could read and access it$ touch file.onunload

2. Run "onunload" to take data form the database
let's say:
file name = file.onunload
database name = wahyudb
table name = customer

$ onunload -t file.onunload wahyudb:customer

3. Then it will create binary file named file.onunload

4. Move file.onunload to onother machine (I was using ftp program)

5. Remember, before you run onload, you have to shutdown down your database

6. Then run onload
let's say:
file name = file.onunload
dbspace name = space1
database name = wahyudb
table name = customer

$ onload -t file.ounlload -d space1 wahyudb:customer

Tidak ada komentar: