On Fri, 18 Feb 2005 12:47:27 -0500, kc68@stripped <kc68@stripped> wrote:
> I still haven't been able to run mysqldump on XP, which we discussed
> (below). The basic problem is that I can't get to c:\mysql\bin and maybe
> that's because MySql installs deep in directories, i.e. in c:\Documents
It doesn't matter where the installation is, you can check the "icon"
you have on your desktop to located where it is, sorry, but if you
can't find it, you won't be able to deal with MySQL properly for lack
of knowledge of the OS.
> and Settings\My Name\Mysql-4.1.9 I start mysql by clicking on a desktop
> icon which starts both the server and the client. When I type quit, it
MySQL Server usually installs as a service in XP, that means when you
start your machine, you start MySQL, you don't need to command its
start, if you do, you should check the installation.
> exits everything, not just the client as happens on my Win98 machine,
> though I think the server keeps running here (XP). I've actually
> uninstalled MySql; should I reinstall MySql at c:\ ? Sorry, seems simple,
> but I can't get it to work.
Ok, lets go back to your problem, you MUST find the installation
directory, now, you're using XP, that means you could simply locate
the file "mysql.exe" using Start - Find - Files and Folders and you'll
have your installation directory. Another thing, if you build a .bat
"<installation directory>/bin/mysqldump.exe" <user, pass and dump
syntax> > <filename>
"<installation directory>/bin/mysqladmin.exe" <user and password
The only parts you have to change are the ones enclosed by <>, but not
the > between the syntax and the filename for the dump, because that
directs the output to that file. Include the quotes too.
If you can't follow this, I guess you should ask a experienced
computer operator or teacher for help. Not everything can be explained
by email and MySQL is a database server, not a simple thing to deal
Daniel da Veiga
Computer Operator - RS - Brazil