How to Load Standard Test Data

Owned by Former user (Deleted)
Last updated: Mar 11, 2011 by Jeff Brewster (Unlicensed)Version comment
2 min read

Earlier documentation on Test Data.

Test Data Set

For version 1.1 functional testing, we used a set of test data created by IBM Dublin.

The standard functional test data set and data set description were stored in the mifos.org resource repository: http://www.mifos.org/knowledge/resources/qa-testing.

In addition, the test data sets were stored in our source repository. The test data directory can be found in the source repository at: documents/test-datahttps://mifos.dev.java.net/svn/mifos/documents/test-data

Steps for loading data

1. Drop the current DB - can use the mySQL Admin GUI , highlight the DB in catalogs, right click and select "Drop" 2. From mySQL command line execute command mySQL> create database mifos_small; 3. Once created no need to put the old schema and data sql files back in, just do a restore through the Admin GUI 4. Go to Restore option in the menu, click "Open Backup file" in bottom right of screen 5. Select the backup file in whatever directory you have it saved, then select Target Schema as "mifos_small" or whatever you have called the Database 6. Click "Start Restore" at bottom right of screen and data will be restored. 7. Restart the Application server and verify the restored data is there, also can check the data through MySQL Query Browser

(steps provided by Mark Kavanagh)

Steps to create backup of the Database

1. Open MySQL Administrator GUI if you don't have shortcut can be found at : Start -> All Programs -> MySQL -> MySQL Administrator 2. Select "Backup" from the Left pane menu 3. Click "New Project" at bottom right of screen 4. Give Project meaningful name, Database name describing Mifos Size and Date backup taken i.e Mifos_Small_Base_Data 5. Select the Schema from the menu , i.e "mifos_small" and click the arrow to put the data into the Backup Content area 6. Click "Execute Backup Now" button at bottom right of screen 7. Dialog box opens asking you where to save the .sql file and what to call it. Save it wherever you want to keep the backups and call it relevant name so can restore at any time e.g My_Test_Data_20080311.sql. Click Save and backup will execute.

(steps provided by Mark Kavanagh)