On 02/01/2010 06:38 PM, kebede teferi wrote:
Hi, I'm very new to this and I need help.
What I want to do is to execute a source command statement from cmd to create
tables and populate them on a data base that I created in Mysql. Here is what
I did at CMD:
*I changed the directory from c:\> to mysql
*At mysql prompt i used -u root -p that prompted me to give my password.
*I put in my password and I was allowed to access the mysql server.
*I used the 'the use --database' command and I can see the database I created
is active and waiting to be worked on.
*then to run the script which is on a note pad with the name create and file
type: sql I typed the following at the mysql prompt:
*source create.sql;
I get the error message '2' and '22' whichever way I tried the source
command. I appreciate your help
Kebede Teferi
mysql looks in the current directory for the source file. That the
directory where you ran the mysql client from. The quickest fix is to
give the complete path to the file, e.g. source /home/me/mysourcefile.sql
(You say yoiu changed your current directory to mysql but didn't give us
the complete path. There are multiple mysql directories in most
configurations.)
--John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org