userguide:export_db
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
userguide:export_db [2009/12/02 15:13] 132.168.73.9 |
userguide:export_db [2016/07/25 10:54] (current) 132.168.72.225 |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Database Export ===== | + | ====== Database Export ====== |
| Many validated identification results can be exported within a relational database. | Many validated identification results can be exported within a relational database. | ||
| - | This feature requires : | + | This feature requires |
| - | * Postgresql 8.1 | + | * Postgresql |
| * an existing database | * an existing database | ||
| - | ==== Installing Postgresql ==== | + | For more information on MSI db, see [[..:msidb|corresponding page]] |
| - | {{:userguide:postgres-install-msi.png?400}} | + | |
| - | * Execute PostgreSQL 8.1.msi | + | |
| - | * Follow instructions | + | |
| - | * Note : master password needs to be set at this stage | + | |
| + | ===== Connecting to a database ===== | ||
| + | * Disconnect from the database and quit pgAdmin III | ||
| + | * Go back to IRMa | ||
| + | * In IRMa preferences select the DB export tab | ||
| + | * Under Connection settings, select Edit | ||
| + | {{:userguide:connecting-to-database-1.png?300}} | ||
| - | === Setting up a database === | + | * Test connexion to make sure you can access the DB |
| - | {{:userguide:setting-up-database.png?600}} | + | {{:userguide:connecting-to-database-2.png?300}}{{:userguide:connecting-to-database-3.png?250}} |
| - | {{:userguide:setting-up-database-2.png?600}} | + | * Make sure that under the tab « Saved elements » you deselect the export of unassigned queries and peptides (this slows down the transfer and tracks quite useless information) |
| + | {{:userguide:connecting-to-database-4.png?300}} \\ | ||
| - | Under user « postgres » : | ||
| - | * Connect to database (dble_click) | ||
| - | * Create new user « example » with permission to login and create a database | ||
| - | * Disconnect from database (R-click) | ||
| - | * Reconnect under « example » username (cf. above) | ||
| - | {{:userguide:setting-up-database-3.png?500}} | ||
| - | {{:userguide:setting-up-database-4.png?600}} | + | * {{:userguide:connecting-to-database-5.png?500}} |
| - | * Select database Uppsala and click the button « execute arbitraty sql queries » | + | |
| - | * In query window select file/open | + | |
| - | * Select the file MSIDBModel (previously named ExportDBModel) included in the IRMa installation folder | + | |
| - | * All the queries necessary to create the MSidb are now open | + | |
| - | {{:userguide:setting-up-database-5.png?500}} \\ | + | * **You’re ready to export** |
| - | {{:userguide:setting-up-database-6.png?400}} \\ | + | {{:userguide:connecting-to-database-6.png?500}} |
| - | {{:userguide:setting-up-database-7.png?400}} \\ | + | |
| - | * Execute the queries | + | |
| - | * The database gets populated with all the tables IRMa needs to store identifications data | + | |
| - | |||
| - | For more information on MSI db, see [[..:msidb|corresponding page]] | ||
userguide/export_db.1259763229.txt.gz · Last modified: 2009/12/02 15:13 by 132.168.73.9
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
