Mysql command prompt question

Forum Moderators: open

Message Too Old, No Replies

Mysql command prompt question

How comes it works only under win command prompt?

hadi00

7:15 pm on Mar 12, 2008 (gmt 0)

hello friends,
I started few days ago trying to use mysql prompt to try adding, dropping, ... etc my data bases. I noticed that nothing worked with my through the mysql prompt command window, and errors like 1064 (42000) kept showing up asking me to be fix my syntax even though it was correct!
So I tried after that "and I don't know why," to use the windows command window to connect my sql , "by the way I am working with local server on my pc", and it finally worked!
I want to know why it is not working directly thrugh mysql window ? caue I am facing new problem to make :Iconv tool works also too..
thnx all

coopster

7:21 pm on Mar 13, 2008 (gmt 0)

Welcome to WebmasterWorld, hadi00.

I download and unzip to my own directory and use the command prompt on Windows installations.

What "MySQL prompt" are you referring to? I've never used the Windows Installer (executable) version myself, so if you used that to install I would not be familiar with any bundled tools.

hadi00

8:10 pm on Mar 13, 2008 (gmt 0)

hi thnx for replying me,
I mean mysql commands like :


mysqldump --user=something --password=something some db > db.sql;

These commands always return an error while using Mysql command client, but I can use it with windows'xp sp2' one.
If u ask why I am asking while I finally can do commands well , actually I want to understand this cause I have some similer problem with Iconv commands. I can't use them at all, so I thought if there is some way these things work with , I could possibly under stand the rest . maybe ?
Thank you

coopster

8:23 pm on Mar 13, 2008 (gmt 0)

These commands always return an error while using Mysql command client

What is this? What is the Mysql command client to which you refer?

hadi00

11:33 am on Mar 15, 2008 (gmt 0)

sorry to be late,
the mysql command client in windows, looks like the command screen that u can run ur self on winxp by the following : Start > Run > Cmd.exe;
so mysql client is very similer to this one ,,,

rocknbil

2:58 pm on Mar 15, 2008 (gmt 0)

mysqldump --user=something --password=something some db > db.sql;

Is not an internal mysql command. Mysqldump is an external program, although I've never tried it while in mysql, it should be executed after exiting mysql. If this is the problem, it may mean mysqldump installed on your local computer but not the server.