Re: Table 'mysql.host' doesn't exist
thomas Armstrong wrote: I created this very-simple '/etc/my.conf': [mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/var socket=/tmp/mysql.sock --- But it doesn't still work. '/usr/local/mysql/var' hosts the data, but within 'mysql' subdirectory, there are only two files: -- -rw-rw 1 mysql root0 may 30 2005 func.MYD -rw-rw 1 mysql root 8877 may 30 2005 tables_priv.frm Where are 'host.frm', 'host.MYD' and 'host.MYI'? Hope you have a backup. The myd file contains all of your data, so without it, you're out of luck. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table 'mysql.host' doesn't exist
I created this very-simple '/etc/my.conf': [mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/var socket=/tmp/mysql.sock --- But it doesn't still work. '/usr/local/mysql/var' hosts the data, but within 'mysql' subdirectory, there are only two files: -- -rw-rw 1 mysql root0 may 30 2005 func.MYD -rw-rw 1 mysql root 8877 may 30 2005 tables_priv.frm Where are 'host.frm', 'host.MYD' and 'host.MYI'? On 7/16/06, thomas Armstrong [EMAIL PROTECTED] wrote: Hi. Working with mySQL 3.23.58 on Linux, I get this error when trying to start mysqld: 060716 03:07:21 mysqld started 060716 03:07:21 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist 060716 03:07:21 mysqld ended - This Linux machine has been working ok for months, and it stopped suddenly. I don't've any idea about how to fix it, and I don't find any '/etc/my.conf' file into this machine. The install directory is '/usr/local/mysql'. Thank you very much in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table 'mysql.host' doesn't exist
On Sunday 16 July 2006 12:34, thomas Armstrong wrote: I don't've any idea about how to fix it, and I don't find any '/etc/my.conf' file into this machine. The install directory is '/usr/local/mysql'. I don't know anything about mysql, but on my system - Fedora 5 - the mysql databases are stored in /var/lib/mysql ; in particular the mysql database is stored in /var/lib/mysql/mysql/ where I see the files host.[frm,MYD,MYI] . -- Timothy Murphy e-mail (80k only): tim /at/ birdsnest.maths.tcd.ie tel: +353-86-2336090, +353-1-2842366 s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table 'mysql.host' doesn't exist when try to start mysqld
Amanda Shuler wrote: I get the following error when I try to start to start mysqld: 010926 2:23:55 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist I am a total newb and I don't have any idea how to get around this. Any ideas? Who ever installed mysql did not run 'scripts/mysql_install_db.sh' Said person should read INSTALL-SOURCE in the source tar ball. --Bill - 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