Reconfigure the database » History » Version 14
Amber Herold, 10/29/2010 04:38 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 | 11 | Amber Herold | # Copy "config.php":http://emg.nysbc.org/attachments/503/config.php to */var/www/html/myamiweb* |
| 23 | 13 | Amber Herold | |
| 24 | # Change the permission of the config file |
||
| 25 | 12 | Amber Herold | <pre> |
| 26 | chmod 777 /var/www/html/myamiweb/config.php |
||
| 27 | </pre> |
||
| 28 | 1 | Amber Herold | # Point your web browser to http://localhost/myamiweb/setup |
| 29 | ## The database username is *root* |
||
| 30 | ## There is no database password. Leave this field empty. |
||
| 31 | 6 | Amber Herold | ## Click *Next* on each page without making any changes. |
| 32 | ## Eventually, you will see a button to *Create Web Tools Config*. Click on this button, and ignore the Apache User error. |
||
| 33 | ## Click on the *DB Initialization* button. |
||
| 34 | ## Click *Next*. |
||
| 35 | ## Click *Next* to insert default values. |
||
| 36 | ## You will need to enter information for the Adminstrator Appion user. You may enter any password and your email address. |
||
| 37 | ## 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. |
||
| 38 | 8 | Amber Herold | |
| 39 | 6 | Amber Herold | # Delete the sample images folder |
| 40 | <pre> |
||
| 41 | cd /myamiImages/leginon |
||
| 42 | rm -rf sample |
||
| 43 | </pre> |
||
| 44 | 10 | Amber Herold | # Point your browser to the following url but first replace *your_root_password* with the root password of your CentOS installation. |
| 45 | 7 | Amber Herold | <pre> |
| 46 | 10 | Amber Herold | http://localhost/myamiweb/setup/autoInstallSetup.php?password=your_root_password |
| 47 | 7 | Amber Herold | </pre> |