$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 4.1.16 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE urlmarkr; Query OK, 1 row affected (0.42 sec) mysql> GRANT ALL PRIVILEGES ON urlmarkr.* TO username@localhost IDENTIFIED BY 'password-goes-here' WITH GRANT OPTION; Query OK, 0 rows affected (0.37 sec) % cp config/database.yml.orig config/database.yml % vi config/database.yml $ cat config/database.yml development: adapter: mysql database: urlmarkr username: user password: password host: mysqlhost % cp config/environment.rb.orig config/environment.rb % vi config/environment.rb % rake migrate <- revision 37ではmigrationがうまくいかず (in /somewhere) CreateBookmarks: migrating ===============================================
—create_table(:bookmarks) → 0.3062s
CreateBookmarks: migrated (0.3063s) ====================================== CreateTags: migrating ====================================================
—create_table(:tags) → 0.1663s
CreateTags: migrated (0.1665s) =========================================== CreateOptions: migrating =================================================
—create_table(:options) → 0.1076s
CreateOptions: migrated (0.1078s) ======================================== CreatePreferences: migrating =============================================
—create_table(:preferences) → 0.0246s
CreatePreferences: migrated (0.0248s) ====================================rake migrateがうまくいかないときは、
% mysql -u username -p urlmarkr < db/urlmarkr.sql