Reconfigure the database » History » Version 10
Amber Herold, 10/29/2010 04:26 PM
| 1 | 1 | Amber Herold | h1. Reconfigure the database |
|---|---|---|---|
| 2 | |||
| 3 | # Drop the databases if they exist |
||
| 4 | |
||
| 5 | <pre> |
||
| 6 | mysql -h localhost -u root |
||
| 7 | |||
| 8 | show databases; |
||
| 9 | </pre> |
||
| 10 | If you see: |
||
| 11 | 3 | Amber Herold | _projectdb |
| 12 | leginondb_ |
||
| 13 | 1 | Amber Herold | <pre> |
| 14 | drop database projectdb; |
||
| 15 | drop database leginondb; |
||
| 16 | </pre> |
||
| 17 | # Create the databases |
||
| 18 | <pre> |
||
| 19 | create database projectdb; |
||
| 20 | create database leginondb; |
||
| 21 | </pre> |
||
| 22 | # Copy config.php to */var/www/html/myamiweb* |
||
| 23 | |
||
| 24 | # Point your web browser to http://localhost/myamiweb/setup |
||
| 25 | ## The database username is *root* |
||
| 26 | ## There is no database password. Leave this field empty. |
||
| 27 | 6 | Amber Herold | ## Click *Next* on each page without making any changes. |
| 28 | ## Eventually, you will see a button to *Create Web Tools Config*. Click on this button, and ignore the Apache User error. |
||
| 29 | ## Click on the *DB Initialization* button. |
||
| 30 | ## Click *Next*. |
||
| 31 | ## Click *Next* to insert default values. |
||
| 32 | ## You will need to enter information for the Adminstrator Appion user. You may enter any password and your email address. |
||
| 33 | ## When this completes, you may start using Appion, or may continue with the following steps to insert a sample project into the database which can be used for processing with Appion. |
||
| 34 | 8 | Amber Herold | |
| 35 | 6 | Amber Herold | # Delete the sample images folder |
| 36 | <pre> |
||
| 37 | cd /myamiImages/leginon |
||
| 38 | rm -rf sample |
||
| 39 | </pre> |
||
| 40 | 10 | Amber Herold | # Point your browser to the following url but first replace *your_root_password* with the root password of your CentOS installation. |
| 41 | 7 | Amber Herold | <pre> |
| 42 | 10 | Amber Herold | http://localhost/myamiweb/setup/autoInstallSetup.php?password=your_root_password |
| 43 | 7 | Amber Herold | </pre> |