> On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote:
> >mysql>
> >
> >mysql> \R shell>
> >PROMPT set to 'shell>'
> >
> >shell>
It doesn't matter what the prompt says, it's still mysql you're
running here. When people say "the shell prompt" they don't mean
"make your prompt say the word shell", they
I did have some luck, y'all after several hours.
Originally there wasn't a mysqldump.exe in the bin
folder so I redid everything. I went through regular
ole ms-dos and was able to run it through fine.
I just needed it to get converted to a .sql file so I
can upload it to my web server. I discove
alf way
down the page)
Ben Wiechman
-Original Message-
From: Gary Josack [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 24, 2007 6:50 AM
To: Red Hope
Cc: mysql@lists.mysql.com
Subject: Re: mysql dump help!
Red Hope wrote:
> I'm curious about one thing. When I go into MySQL
>
Red Hope wrote:
I'm curious about one thing. When I go into MySQL
folder on the hard drive. I go into the 'bin' folder,
should there be an .exe program called mysqldump? or
not?
Lillian
--- Carlos Proal <[EMAIL PROTECTED]> wrote:
Yep, good for you, welcome to the "real" world
You are chan
did u try this
mysqldump -u root -ppassword --database test > test.sql
On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote:
I'm curious about one thing. When I go into MySQL
folder on the hard drive. I go into the 'bin' folder,
should there be an .exe program called mysqldump? or
not?
Lillian
I'm curious about one thing. When I go into MySQL
folder on the hard drive. I go into the 'bin' folder,
should there be an .exe program called mysqldump? or
not?
Lillian
--- Carlos Proal <[EMAIL PROTECTED]> wrote:
>
> Yep, good for you, welcome to the "real" world
> You are changing the prompt
I cut and pasted what you typed and just altered the
password. It didn't like it all. Same error again. If
I put any command in without the ";" at the end then
I'll get locked into this "->" thingy unless I clear
out. I can't guess why it won't take it.
Lillian
--- Ananda Kumar <[EMAIL PROTECTED
Yep, good for you, welcome to the "real" world
You are changing the prompt but are still inside the dbms, you need to
get out, because mysqldump is an application (.exe file) not a sql
command, ie
Welcome to the MySQL monitor
try this
mysqldump -u root -ppassword --database test > test.sql
On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote:
Hey y'all,
I use charming Windows XP on here. I've taken database
classes but lucky for me we never used *real* MySQL.
Below I typed up exactly what I put into the MySQL
prompt and
Hey y'all,
I use charming Windows XP on here. I've taken database
classes but lucky for me we never used *real* MySQL.
Below I typed up exactly what I put into the MySQL
prompt and this is what it kicks back to me.
Lillian
mysql>
mysql> \R shell>
PROMPT set to 'shell>'
shell>
shell>mysqldu
I think we are daling with a windows user, who are not
that familiar with a command prompt. Correct me if
i'm wrong. How to get to a point where you would be
able to execute a mysqldump, will depend on what OS
you are running, and how you installed MySQL.
On Tue, July 24, 2007 04:41, Carlos Proal
mysqldump -u -p -q --single-transaction --tab=/dest/dir database
or
mysql -u root -p database > output.sql
On Tue, July 24, 2007 03:16, Red Hope wrote:
> Hey y'all,
> I've been fussing with the MySQL dump procedure to
> backup my stuff. I'm on MySQL 5.0.41 and I have tried
> so hard to get it t
Can you email us the complete command and the error ?
Carlos
Red Hope wrote:
Well, that went over my head. :) I understand what
you're telling me, how to get there, but not how to do
it. bleh.
When I start up MySQL Command Line Client, I'm always
prompted at "mysql>". So I told it to swi
Well, that went over my head. :) I understand what
you're telling me, how to get there, but not how to do
it. bleh.
When I start up MySQL Command Line Client, I'm always
prompted at "mysql>". So I told it to switch from that
prompt to "shell>" prompt. It always starts up in
"mysql>" prompt. Onc
Well hopefully, typing "quit" at the mysql console get you back to the
shell.
Otherwise, you need to open a Gnome Console, KDE Konsole or Windows
CommandPrompt from the different menus on your operating system
If the mysql directory is on your PATH you can use mysqldump anywhere,
if not, m
Oh boy, and here's the big stupid question. How do I
get to the shell prompt? Sorry! Yea, I'm that newbie.
:)
Thank you,
Lillian
--- Carlos Proal <[EMAIL PROTECTED]> wrote:
>
> One common error is trying to do this inside the
> mysql console, instead
> of the shell prompt, i think thats your
One common error is trying to do this inside the mysql console, instead
of the shell prompt, i think thats your problem because at least the
first one is correct.
Carlos
Red Hope wrote:
Hey y'all,
I've been fussing with the MySQL dump procedure to
backup my stuff. I'm on MySQL 5.0.41 and I
17 matches
Mail list logo
