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. Once I'm in shell, I tried the dump procedure and it kept saying it couldn't connect. So I checked what databases it had, it shows them. I can't even switch to a database because of no connection. I'm not exactly sure why there's no 'connection' at all. Thanks for trying so hard, Carlos! Lillian --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > 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, move to the mysql/bin directory and then you > can run it without > any problem. > > Hope that help. > > Carlos > > > Red Hope wrote: > > 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 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 have > >>> > >> tried > >> > >>> so hard to get it to dump my files into .sql > >>> > >> format > >> > >>> but my syntax is wrong, wrong, wrong. lol > >>> > >>> I put below examples what I've been entering to > >>> > >> get my > >> > >>> databases backed up. I always get an error or I > >>> > >> get > >> > >>> locked into the "->" thing if I don't use the > >>> semicolons. > >>> > >>> Any help would be awesome! > >>> Thank you, > >>> Lillian > >>> > >>> Tried & Wrong > >>> mysqldump -u root -ppassword test > test.sql > >>> mysqldump -u root -ppassword test > test.sql; > >>> mysqldump -u root -ppassword -databases test > > >>> test.sql; > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > > > ____________________________________________________________________________________ > > > >>> Yahoo! oneSearch: Finally, mobile search > >>> that gives answers, not web links. > >>> > >>> > > > http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC > > > >>> > >>> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >> > >> > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > >> > > > > > > > > > > > ____________________________________________________________________________________ > > Take the Internet to Go: Yahoo!Go puts the > Internet in your pocket: mail, news, photos & more. > > http://mobile.yahoo.com/go?refer=1GNXIC > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > ____________________________________________________________________________________ Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]