• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql

 
david allen
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I remember doing this at uni but I cant remember how. I am creating a database in mysql and entering all of the commands. I wanted to put these in a file and then execute the file. Just incase I have to move the site to another machine later on.
I have created a file called lodge.sql
it contains sql that creates a very simple table.
I then goto the mysql prompt and enter - lodge.sql
I then get the following error. 1064.
I have the correct permissions.
Any ideas.
Thank you
david
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's:

(edited for typo)
[ August 20, 2003: Message edited by: Jeanne Boyarsky ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic