source: subversion/sites/rails_port/db/README @ 2489

Last change on this file since 2489 was 1627, checked in by steve, 13 years ago

add docs from dpenezic@…

File size: 946 bytes
Line 
1Creating database
2=====================
3
4OSM server use databse with follow name :
5
6openstreetmap
7
8You may create it with your prefrable client or run next (linux) command :
9
10$ mysqladmin -u <uid> -p create openstreetmap
11
12(change <uid> with appropriate username of administrativ user eg. root )
13
14Creating user, password, and access rightts
15=============================================
16
17$ mysql -u <uid> -p
18
19(change <uid> with appropriate username of administrativ user eg. root )
20
21> grant all privileges on openstreetmap.* to 'openstreetmap'@'localhost' identified by 'openstreetmap';
22> flush privileges;
23> exit
24
25Creating database skeleton tables
26===================================
27
28$ mysql openstreetmap -u openstreetmap -p < db/create_database.sql
29
30New server patch (RAILS)
31==========================
32
33Run follow command to prepare tables to be OSM REILS distribution compatible :
34
35$ mysql openstreetmap -u openstreetmap -p < db/migrate.sql
36
Note: See TracBrowser for help on using the repository browser.