Test Data Set
For version 1.1 functional testing, we will use a set of test data created by IBM Dublin.
The standard functional test data set and data set description can be copied from the mifos.org resource repository: http://www.mifos.org/knowledge/resources/qa-testing.
In addition, the test data sets are current stored in our source repository. The test data directory can be found here: https://mifos.dev.java.net/svn/mifos/documents/test-data
If you are not set up to access the source code repository, you can refer to directions here: http://www.mifos.org/developers/install-mifos/get-source-code
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 latest-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)