source db/slideshow_data.sql

From examples / Ruby on Rails Up and Running · GitLab I downloaded src-start- chapter-4.zip and extraced the following file, which fails to import correctly. Is this a syntax problem, a database password problem, or what?

thufir@arrakis ~/oreilly-photos $ thufir@arrakis ~/oreilly-photos $ cat db/slideshow_data.sql -n | head -n 2      1 insert into slideshows values (1, 'Interesting pictures', now());      2 insert into slides values (1, 1, 1, 1); thufir@arrakis ~/oreilly-photos $ thufir@arrakis ~/oreilly-photos $ source db/slideshow_data.sql bash: db/slideshow_data.sql: line 1: syntax error near unexpected token ` (' bash: db/slideshow_data.sql: line 1: `insert into slideshows values (1, 'Interesting pictures', now())' thufir@arrakis ~/oreilly-photos $ thufir@arrakis ~/oreilly-photos $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43 Server version: 5.0.44-log Gentoo Linux mysql-5.0.44

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

From http://examples.oreilly.com/rubyrails/ I downloaded src-start- chapter-4.zip and extraced the following file, which fails to import correctly. Is this a syntax problem, a database password problem, or what?

Just to clarify, it can be done, but not at all in the way which the oreilly book says:

thufir@arrakis ~/oreilly-photos $ thufir@arrakis ~/oreilly-photos $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 47 Server version: 5.0.44-log Gentoo Linux mysql-5.0.44

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.