I apologize for the newbie question, but I've been through the docs [and
the DuBois book] and I'm just not quite figuring it out.... I want to run
a private, local copy of mysqld so I can do some expermenting and fooling
around without getting in the way of our production use of mysqld.
I did a 'mkdir /home/me/.mysql' to serve as my private data directory,
and i figured I'd use a unix-domain socket so that I wouldn't have any
possibility of crossing paths iwth an in-use TCP port... and so I
naively tried:
$mysql/libexec/mysqld --datadir=/home/me/.mysql --socket=/tmp/mysql.me
Can't start server: Bind on TCP/IP port: Address already in use
It is clearly still trying to do the inet domain socket, so I tried:
$mysql/libexec/mysqld --datadir=/home/me/.mysql --socket=/tmp/mysql.me \
--port=-1
and that seemed closer --- mysqld actually created the socket in /tmp
but it complained about:
/usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
Apparently, you can't start up a fresh version of mysqld with just an
empty directory for its 'datadir'... I looked through DuBois and I
didn't see a mention of what stuff was required in a data directory or
how to get it there... I'd appreciate a 'howto' [or a ptr to the docs or
whatever] for what I need to do to get the new datadirectory set up.
THANKS!
/Bernie\
--
Bernie Cosell Fantasy Farm Fibers
mailto:[EMAIL PROTECTED] Pearisburg, VA
--> Too many people, too few sheep <--
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
