Dump/Load

Database Dump Methods

Database Load Methods

MFG/PRO Dump/Load

  1. Ensure you are the only user logged into MFG/PRO.
  2. Back up the old database.
  3. Run MFG/PRO Dump/Load.  
  4. Reload data into the desired database. – Usually a copy of mfgempty.

You should perform dump/loads in Host mode for UNIX, and in batch mode on the character admin client in NT.

Load Procedure Notes

MFG/PRO Load Procedures

  1. Place .d files in load directory.
  2. Run Database File Dump/Load w/ Batch choosing LOAD.
  3. Check dumpload.e, dumpload.log.

There is no performance advantage to performing a multi-stream load.

Dumping and Loading Data in MFG/PRO

Dumping Through MFG/PRO

Overview: In this activity, you will be dumping a single table, prd_det, using the dump/load program in MFG/PRO.

Prerequisites:

  1. View the output to be deleted.

Note the various printer definitions.

  1. Select Database File Dump/Load w/Batch (36.21.4 / 36.16.4), and enter the following

Field

Enter

Database Name

Defaults to physical name of primary database.

Dumpfile Directory

. (YourWorkingDir)*

Dump/Load

Dump

File Name

prd_det

To

prd_det

Allow Errors, Log file

These fields are display only.

* This program attempts to append a forward slash (/) to the end of the directory entered here. This is a problem on Windows where a backslash is expected (\). Using your working directory for this class will get around this issue. Press OK at the Continue with Dump/Load prompt, and enter the following

  1. Press OK at the Continue with Dump/Load prompt, and enter the following

Field

Enter

Output

Window

Batch ID

Leave this field blank

  1. Choose Go when ready.

Note The report displays the number of records dumped and dump data file name. To view this file, exit to the operating system and check your working directory.

Preparing the Training Database for Load

Overview: For purposes of this training only, follow these steps to delete the standard printer records from your training database.

Warning Do not perform these steps under normal circumstances. They are only applicable to this training activity.

  1. If not start started already, open the PROGRESS Procedure Editor against your training database. To do so, start an MFG/PRO session, select the User Menu, and choose PROGRESS Editor.
  2. In the Procedure Editor, type the following program to delete the printer records. for each prd_det: delete prd_det.
  3. Press Go to run the program.
  4. When the program completes, exit the Procedure Editor and return to MFG/PRO.
  5. Verify the printer record deletes.

Note that all the printer records are no longer present.

Loading Through MFG/PRO

Overview: In this activity you will load the prd_det table using the dump/load program in MFG/PRO.

Prerequisites:

  1. Select Database File Dump/Load w/Batch (36.21.4 / 36.16.4), and enter the following:

Field

Enter

Database Name

 Defaults to physical name of primary database.

Dumpfile Directory

 . (YourWorkingDir)

Dump/Load

Load

File Name

prd_det

To

prd_det

Allow Errors

Yes

Log File

This field is display only.

  1. Press OK at the Continue with Dump/Load prompt, and enter the following:

Field

Enter

Output

dlout

Batch ID

Leave this field blank

  1. Choose Go when ready.
  2. Press the Spacebar to acknowledge the warning that occurs.

A file named dlout is created. This file contains any load output.

  1. Verify the printer records load.

Notice that the printer records are again available.