On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option in my.cnf:
socket="/tmp/mysql.sock"
when i `mysqladmin -u root shutdown` the database, the mysql.sock is removed.
does your system errors when starting mysqld?
Hello Danny,
Thanks for the info. With it, I've gotten considerably further down the
road before my next blow out. I've relocated mysql to /usr/local/mysql,
and then made /usr/local/mysql/tmp my data directory, as I was getting
errors that my local account "mysql" didn't have permission to create
./ibdata1.
Once that was accomplisghed, the following appeared to accomplish the db
creation:
./mysqld_safe --user=mysql --datadir=/usr/local/mysql/tmp
Now I have the following in my /usr/local/mysql/tmp directory:
ls -l
total 41014
-rw-rw---- 1 mysql Other 2870 Jun 16 13:29 hazy.err
-rw-rw---- 1 mysql nobody 5242880 Jun 16 13:29 ib_logfile0
-rw-rw---- 1 mysql nobody 5242880 Jun 16 13:22 ib_logfile1
-rw-rw---- 1 mysql nobody 10485760 Jun 16 13:27 ibdata1
significantly, the hazy.err file contains:
050616 13:29:26 mysqld started
050616 13:29:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050616 13:29:26 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050616 13:29:26 InnoDB: Flushing modified pages from the buffer pool...
050616 13:29:26 InnoDB: Started; log sequence number 0 43634
050616 13:29:26 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050616 13:29:26 mysqld ended
So far, I haven't found anything on the net which corrects this situation,
though the error shows up with pretty good regularity.
I made sure that I had a datadir definition in /etc/my.cnf:
datadir=/usr/local/mysql/tmp
but that doesn't seem to have corrected the problem.
Paul
==============================================================================
Paul Mitchell
email: [EMAIL PROTECTED]
phone: (919) 962-9778
office: I have an office, room 14, Phillips Hall
==============================================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
