Hello all,

I am tyring to install on Ubuntu 6.06 and I’ve run into a roadblock with loading the schema into the empty database. When I run “rake migrate” I get the following:
——————————
jglasson@mrheffe-ubuntu:~/sites/tracks_1.042$ rake migrate
(in /home/jglasson/sites/tracks_1.042)
rake aborted!
Mysql::Error: Lost connection to MySQL server during query: SELECT version FROM schema_info

(See full trace by running task with—trace)
jglasson@mrheffe-ubuntu:~/sites/tracks_1.042$
——————————-

If I try the alternate method listed in the install docs (rake db_schema_import) I get the following:
——————————-
jglasson@mrheffe-ubuntu:~/sites/tracks_1.042$ rake db_schema_import
(in /home/jglasson/sites/tracks_1.042)
—create_table(“contexts”, {:force=>true})
rake aborted!
Mysql::Error: Lost connection to MySQL server during query: CREATE TABLE contexts (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255) DEFAULT ‘’ NOT NULL, `hide` int(4) DEFAULT 0 NOT NULL, `position` int(11) DEFAULT 0 NOT NULL, `user_id` int(11) DEFAULT 1) ENGINE=InnoDB

(See full trace by running task with—trace)
jglasson@mrheffe-ubuntu:~/sites/tracks_1.042$

Kinda stuck here - please advise..

Thanks,
Jeffrey

Are you sure that you’ve:

a) got MySQL installed properly (can you create databases and connect to them from other applications?)
b) got the MySQL ruby bindings installed, since that’s often a common cause of problems connecting. It ought to work without them, but in some cases and on some platforms, it doesn’t work. If you’ve got gems installed, try:

gem install ruby-mysql

Another thought: can you check that your database.yml file doesn’t contain any tab characters (it should be just spaces). That totally throws rake or anything else that uses the information in database.yml.