I NEED HELP ON "SOURCE(/.) MYSQL

--0-1764004999-1265067488=:22126
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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 crea=
te tables and populate them on a data base that I created in Mysql.=A0 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 creat=
ed is active and waiting to be worked on.
*then to run the script which is on a note pad with the name create and fil=
e type: sql I typed the following at the mysql prompt:
*source create.sql;
=A0 I get the error message '2' and '22' whichever way I tried the source c=
ommand.=A0 I appreciate your help

Kebede Teferi

=0A
--0-1764004999-1265067488=:22126--

Re: I NEED HELP ON "SOURCE(/.) MYSQL

How did you type the source command? Did you remember not to quote the file=
=20
name? E.g.

mysql> SOURCE schema.sql

is the correct way.

Jesper

On Tue, 2 Feb 2010 10:38:08 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 sou=
rce
> command.  I appreciate your help
>
> Kebede Teferi


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: I NEED HELP ON "SOURCE(/.) MYSQL

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=gcdmg-mysql-2@m.gmane.org

Re: I NEED HELP ON "SOURCE(/.) MYSQL

Error 2 is "No such file or directory"

So, probably the file is not in the right path or you need to explicitly
provide the path to the file.

Carlos


On 2/1/2010 5: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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: I NEED HELP ON "SOURCE(/.) MYSQL

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=gcdmg-mysql-2@m.gmane.org

Re: I NEED HELP ON "SOURCE(/.) MYSQL

R2l2ZSB0aGUgZnVsIHBhdGggb2YgZmlsZSBuYW1lIHdpdGggaW4gJycgYW5k IHRyeSBpdCBvdXQg
DQoNClRoYW5rcw0KU3VyZXNoIEt1bmENCk15U1FMIERCQQ0KLS0tLS0tT3Jp Z2luYWwgTWVzc2Fn
ZS0tLS0tLQ0KRnJvbTogQ29saW4gU3RyZWljaGVyDQpUbzogbXlzcWxAbGlz dHMubXlzcWwuY29t
DQpDYzoga2ViZWRlIHRlZmVyaQ0KUmVwbHlUbzogY29saW5Ab2J2aW91c2x5 bWFsaWNpb3VzLmNv
bQ0KU3ViamVjdDogUmU6IEkgTkVFRCBIRUxQIE9OICdTT1VSQ0UoXC4pIE1Z U1FMDQpTZW50OiBG
ZWIgMiwgMjAxMCA3OjMzIEFNDQoNCndoYXQgZXZlcnlvbmUgZWxzZSBzYWlk Li4uIGFsc28sIGlz
IHRoZXJlIGEgbG9uZ2VyIHZlcnNpb24gb2YgdGhlIGVycm9yPyBvciBpcyBp dCBsaXRlcmFsbHkg
ZXJyb3IgMiANCm9yIGVycm9yIDIyPw0KDQpDb2xpbg0KDQpPbiBGZWJydWFy eSAxLCAyMDEwIDA2
OjM4OjA4IHBtIGtlYmVkZSB0ZWZlcmkgd3JvdGU6DQo+IEhpLCBJJ20gdmVy eSBuZXcgdG8gdGhp
cyBhbmQgSSBuZWVkIGhlbHAuDQo+IA0KPiBXaGF0IEkgd2FudCB0byBkbyBp cyB0byBleGVjdXRl
IGEgc291cmNlIGNvbW1hbmQgc3RhdGVtZW50IGZyb20gY21kIHRvDQo+ICBj cmVhdGUgdGFibGVz
IGFuZCBwb3B1bGF0ZSB0aGVtIG9uIGEgZGF0YSBiYXNlIHRoYXQgSSBjcmVh dGVkIGluIE15c3Fs
LiANCj4gIEhlcmUgaXMgd2hhdCBJIGRpZCBhdCBDTUQ6ICpJIGNoYW5nZWQg dGhlIGRpcmVjdG9y
eSBmcm9tIGM6XD4gdG8gbXlzcWwNCj4gKkF0IG15c3FsIHByb21wdCBpIHVz ZWQgLXUgcm9vdCAt
cCB0aGF0IHByb21wdGVkIG1lIHRvIGdpdmUgbXkgcGFzc3dvcmQuDQo+ICpJ IHB1dCBpbiBteSBw
YXNzd29yZCBhbmQgSSB3YXMgYWxsb3dlZCB0byBhY2Nlc3MgdGhlIG15c3Fs IHNlcnZlci4NCj4g
KkkgdXNlZCB0aGUgJ3RoZSB1c2UgLS1kYXRhYmFzZScgY29tbWFuZCBhbmQg SSBjYW4gc2VlIHRo
ZSBkYXRhYmFzZSBJDQo+ICBjcmVhdGVkIGlzIGFjdGl2ZSBhbmQgd2FpdGlu ZyB0byBiZSB3b3Jr
ZWQgb24uICp0aGVuIHRvIHJ1biB0aGUgc2NyaXB0DQo+ICB3aGljaCBpcyBv biBhIG5vdGUgcGFk
IHdpdGggdGhlIG5hbWUgY3JlYXRlIGFuZCBmaWxlIHR5cGU6IHNxbCBJIHR5 cGVkIHRoZQ0KPiAg
Zm9sbG93aW5nIGF0IHRoZSBteXNxbCBwcm9tcHQ6ICpzb3VyY2UgY3JlYXRl LnNxbDsNCj4gICBJ
IGdldCB0aGUgZXJyb3IgbWVzc2FnZSAnMicgYW5kICcyMicgd2hpY2hldmVy IHdheSBJIHRyaWVk
IHRoZSBzb3VyY2UNCj4gIGNvbW1hbmQuICBJIGFwcHJlY2lhdGUgeW91ciBo ZWxwDQo+IA0KPiBL
ZWJlZGUgVGVmZXJpDQo+IA0KDQotLSANCllvdXIgbG92ZSBsaWZlIHdpbGwg YmUgaGFwcHkgYW5k
IGhhcm1vbmlvdXMuDQoNCi0tIA0KTXlTUUwgR2VuZXJhbCBNYWlsaW5nIExp c3QNCkZvciBsaXN0
IGFyY2hpdmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQpUbyB1 bnN1YnNjcmliZTog
ICAgaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1zdXJlc2hr dW1hcmlsdUBnbWFp
bC5jb20NCg0KDQoNClNlbnQgZnJvbSBCbGFja0JlcnJ5riBvbiBBaXJ0ZWw=