Give the ful path of file name with in '' and try it out
Thanks
Suresh Kuna
MySQL DBA
------Original Message------
From: Colin Streicher
To: mysql@stripped
Cc: kebede teferi
ReplyTo: colin@strippedm
Subject: Re: I NEED HELP ON 'SOURCE(\.) MYSQL
Sent: Feb 2, 2010 7:33 AM
what everyone else said... also, is there a longer version of the error? or is it literally error 2
or error 22?
Colin
On February 1, 2010 06:38:08 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
>
--
Your love life will be happy and harmonious.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1l.com
Sent from BlackBerry® on Airtel