• 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
Sheriff
Posts: 36007
422
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 ]
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!