Don Vu wrote:
Hi guys,
I have a script in my home directory that i want others to be able to run. I 'chmod 777'ed the file and the folder it lives in and people still can't run it when they are at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute that script, even
Hi guys,
I have a script in my home directory that i want others to be able to run. I 'chmod
777'ed the file and the folder it lives in and people still can't run it when they are
at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute
that script, even when i log in
Jarlath,
Tuesday, January 22, 2002, 3:18:33 PM, you wrote:
Script means "a file with SQL statements in it" I suppose.
JH> - Does my script file need to be a .sql file or just a plain .txt file???
The suffix doesn't matter. But inside it there should be a plain text file in UNIX
format of newl
EMAIL PROTECTED]
Subject: Re: Running SQL Scripts
Hi,
This should do the trick
mysql > source /path/to/file.sql
or
shell > mysql databasename < /path/to/file.sql
And it doesn't matter about the file extension.
Kevin
- Original Message -
From: "Jarlath . Hennelly
Hi J,
I think you shoud type of command prompt:
mysql database < file.sql
and this will create the database
Cheers,
Caterina
-Original Message-
From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 2:19 PM
To: MySQL (E-mail)
Subject: Running SQL Scri
The file extension can be anything you like
the command is mysql < file_name
-Original Message-
From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 1:19 PM
To: MySQL (E-mail)
Subject: Running SQL Scripts
Dudes & Dudettes,
I got a SQL script w
t;MySQL (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, January 22, 2002 1:18 PM
Subject: Running SQL Scripts
> Dudes & Dudettes,
>
> I got a SQL script with all the SQL to setup a database. But I can't seem
to
> access the script. I did this before so I know it can be d
Dudes & Dudettes,
I got a SQL script with all the SQL to setup a database. But I can't seem to
access the script. I did this before so I know it can be done, but I've to
do it for a new project, and I can't remeber how.
So I've 2 questions :
- Does my script file need to be a .sql file or just a
