Project

General

Profile

Reconfigure the database » History » Version 11

Amber Herold, 10/29/2010 04:30 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 1 Amber Herold
&nbsp;
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
&nbsp;
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>