Sounds like you have a dodgy zip file, try downloading and extracting it again. This is the contents of my dbscripts/mysql directory:
-sh-3.1$ pwd /home/tomcat/apache-roller-3.1/webapp/roller/WEB-INF/dbscripts/mysql -sh-3.1$ ls -l total 112 -rw-r--r-- 1 tomcat tomcat 6288 Apr 21 19:04 094-to-095-migration.sql -rw-r--r-- 1 tomcat tomcat 1615 Apr 21 19:04 095-to-096-migration.sql -rw-r--r-- 1 tomcat tomcat 2626 Apr 21 19:04 096-to-097-migration.sql -rw-r--r-- 1 tomcat tomcat 4036 Apr 21 19:04 097-to-098-migration.sql -rw-r--r-- 1 tomcat tomcat 1058 Apr 21 19:04 098-to-099-migration.sql -rw-r--r-- 1 tomcat tomcat 5431 Apr 21 19:04 098-to-100-migration.sql -rw-r--r-- 1 tomcat tomcat 1290 Apr 21 19:04 100-to-110-migration.sql -rw-r--r-- 1 tomcat tomcat 6183 Apr 21 19:04 110-to-120-migration.sql -rw-r--r-- 1 tomcat tomcat 1017 Apr 21 19:04 120-to-130-migration.sql -rw-r--r-- 1 tomcat tomcat 14889 Apr 21 19:04 130-to-200-migration.sql -rw-r--r-- 1 tomcat tomcat 937 Apr 21 19:04 200-to-210-migration.sql -rw-r--r-- 1 tomcat tomcat 420 Apr 21 19:04 210-to-230-migration.sql -rw-r--r-- 1 tomcat tomcat 187 Apr 21 19:04 230-to-240-migration.sql -rw-r--r-- 1 tomcat tomcat 1541 Apr 21 19:04 240-to-300-migration.sql -rw-r--r-- 1 tomcat tomcat 1973 Apr 21 19:04 300-to-310-migration.sql -rw-r--r-- 1 tomcat tomcat 20709 Apr 21 19:04 createdb.sql -rw-r--r-- 1 tomcat tomcat 171 Apr 21 19:04 README.txt Toby ----- Original Message ---- From: david <[EMAIL PROTECTED]> To: [email protected] Sent: Sunday, 9 September, 2007 6:04:00 PM Subject: Roller install newbie question (step 4 createdb.sql) Hello roller dev, gurus and users. I have recently decided to upgrade my blog from Blojsom to Roller. I should have done so a long time ago but now I am in a must situation. I have completed all step 3 according to the roller-install-guide.pdf. Step 4 was very disappointing when I discovered the instructions at step 4: Create Roller tables in your database fails because the dbscripts\mysql directory does not have the target sql: createdb.sql. The SQL files that are in the directory stated in the previous sentence appear to be only for a migration or upgrade. I am attempting a new compile install. If this works I plan to move the blog to my Linux box. The particulars follow. Thanks in advance. Please advise, David. OS: Windows XP Roller: version 3.1 MySql: 5.0.41-community-nt MySQL Community Edition (GPL) Jars: all including javamail, hibernate, etc.
