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

Last change on this file since 2764 was 2500, checked in by jochen, 13 years ago

fixed typos

File size: 956 bytes
Line 
1Creating database
2===================
3
4OSM server uses a database with the following name:
5
6openstreetmap
7
8You may create it with your preferable client or run next (linux) command:
9
10$ mysqladmin -u <uid> -p create openstreetmap
11
12(change <uid> with appropriate username of administrative user eg. root )
13
14Creating user, password, and access rights
15============================================
16
17$ mysql -u <uid> -p
18
19(change <uid> with appropriate username of administrative 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 following command to prepare tables to be OSM RAILS distribution compatible:
34
35$ mysql openstreetmap -u openstreetmap -p < db/migrate.sql
36
Note: See TracBrowser for help on using the repository browser.