Changes between Version 30 and Version 31 of ResourceDirectory
- Timestamp:
- Jan 23, 2011, 10:28:56 AM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ResourceDirectory
v30 v31 90 90 SQL scripts can be found in the Resource Directory v2/doc directory. 91 91 92 First, SQL script '''{{{ResourceDirectory_v2_create_user. dump}}}''' should be executed in order to create a DB user. Do it only once, otherwise you'll get the following error (if the user already exists):[[BR]]92 First, SQL script '''{{{ResourceDirectory_v2_create_user.sql}}}''' should be executed in order to create a DB user. Do it only once, otherwise you'll get the following error (if the user already exists):[[BR]] 93 93 {{{ERROR 1396 (HY000) at line 5: Operation CREATE USER failed for 'sensei_rd2'@'%'}}} 94 94 95 Then run the script '''{{{ResourceDirectory_v2. dump}}}''' to create the RD database structure.95 Then run the script '''{{{ResourceDirectory_v2.sql}}}''' to create the RD database structure. 96 96 97 97 SQL scripts can be executed using e.g. MySQL Command Line Client or MySQL Query Browser.[[BR]] … … 100 100 {{{ 101 101 # create DB user 102 mysql -u root -p < C:\path\ResourceDirectory_v2_create_user.dump102 mysql -u root -p < ResourceDirectory_v2_create_user.sql 103 103 Enter password: ************ (root password) 104 104 105 105 # create database structure 106 mysql -u root -p < C:\path\ResourceDirectory_v2.dump106 mysql -u root -p < ResourceDirectory_v2.sql 107 107 Enter password: ************ (root password) 108 108 }}}