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
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 Scripts
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 with all the
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" <[EMAIL PROTECTED]>
To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
Sent
