How can I retrieve the table 'mysql.host' ?
I am working with MySQL on a Windows NT machine. I use Innodb tables. I, usually, switch on MySQL with: mysqld-max --standalone But now, I try this, MySQL crash, and I got the message: mysqld-max: Table 'mysql.host' doesn't exist in the 'mysql.err' file. I have found that I start up MySQL with: mysqld-max -Sg --standalone, then it works. Please, how can I rebuild the 'mysql.host' table to all is OK again? Thanks in advance José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
re: How can I retrieve the table 'mysql.host' ?
Please, can you give me more information about this? I think that in Windows NT the privilege tables are built during installation I think that I have not changed anythink. How can I find if there are problems to MySQL see the privilege tables? Many Thanks. José --- Egor Egorov [EMAIL PROTECTED] escribió: José, Tuesday, September 24, 2002, 10:30:30 AM, you wrote: JF I am working with MySQL on a Windows NT machine. I use JF Innodb tables. I, usually, switch on MySQL with: JF mysqld-max --standalone JF But now, I try this, MySQL crash, and I got the JF message: JF mysqld-max: Table 'mysql.host' doesn't exist JF in the 'mysql.err' file. JF I have found that I start up MySQL with: mysqld-max JF -Sg --standalone, then it works. JF Please, how can I rebuild the 'mysql.host' table to JF all is OK again? Does host table exist? or MySQL server doesn't see privilege tables? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
How much stable is MySQL in a production environment?
Recently I have had some problems to start mysqld and finally I have found that this was due to the mysql database has disappear from the hard disk. I have solved this problem, but I do not remember to delete this database. Now, I have a question and I would like that experimented MySQL users help me, please, due to I would like to use MySQL in a production environment (now I am using it in a development environment). Do you know if is a frequent problem that the mysql database damages suddenly? Have you experience with this type of problems? ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
Sudden problem with Grant Tables on Windows NT
I have installed MySQL on a PC with Windows NT. As the MySQL dir is not on c:, I have copied the 'my.cnf' file to c:, and I have edited it to MySQL work with InnoDB tables. All has been working fine, but suddendly, without change any, when I have tried to start up MySQL with the command mysqld-max --standalone (as usually) I have got the message: mysqld-max: Table 'mysql.host' doesn't exist in the 'mysql.err' file. I have found that I start up MySQL with: mysqld-max -Sg --standalone, then it works. How can I solve the problem to be able to start up mysqld-max with the full functionality (without use -Sg option)? I was thinking that the origin of this problem was that I have not privilege tables on my PC. But I think also that when I install MySQL on Windows NT, the privilege table are being creatend during the installation process (MySQL was woriking fine at the beginning). Please, can you help me? Thanks in advance José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
Problem with my mysqld-max on Windows NT
Hello, I have installed MySQL on a PC with Windows NT. As the MySQL dir is not on c:, I have copied the 'mysql.ini' file to c:, and I have edited it to MySQL work with InnoDB tables. All was working fine, but this morning, when I have tried to startup MySQL with the command mysqld-max --standalone (as usually) I have get the message: mysqld-max: TAble 'mysql.host' doesn't exist in the 'mysql.err' file. I have looking for information about this at google.com, but up to now, I have not been able to solve this problem. Please, can you help me? Thanks in advance José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
MySQL was working fine, but now it doesn't work
Hello, I have installed MySQL on a PC with Windows NT. As the MySQL dir is not on c:, I have copied the 'mysql.ini' file to c:, and I have edited it to MySQL work with InnoDB tables. All has been working fine, but this morning, when I have tried to start up MySQL with the command mysqld-max --standalone (as usually) I have got the message: mysqld-max: Table 'mysql.host' doesn't exist in the 'mysql.err' file. I have found that I start up MySQL with: mysqld-max -Sg --standalone, then it works. How can I solve the problem to be able to start up mysqld-max with the full functionality (without use -Sg option)? Please, can you help me? Thanks in advance José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
Problems to create privilege tables on Windows NT
I have installed MySQL on Windows NT, and I have found that I need to create the privilege tables. I have seen in the documentation that I must use the mysql_install_db.sh script, but I think that it is intended to use in Linux or Unix, not with Windows. I say this due to I have not found it in any of the hard disks that has my PC, where I have installed MySQL. Please how can I create the privilege tables in my Windows NT system? Many Thanks José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
Privilege tables and mysqld-max wiht -Sg option
Hello, in a previous answer, you have said me that if install MySQL on a Windows NT machine, it is not necessary to create privilege tables with 'mysql_insall_db.sh'. The problem is this: I have installed MySQL on a PC with Windows NT. As the MySQL dir is not on c:, I have copied the 'mysql.ini' file to c:, and I have edited it to MySQL work with InnoDB tables. All has been working fine, but this morning, when I have tried to start up MySQL with the command mysqld-max --standalone (as usually) I have got the message: mysqld-max: Table 'mysql.host' doesn't exist in the 'mysql.err' file. I have found that I start up MySQL with: mysqld-max -Sg --standalone, then it works. How can I solve the problem to be able to start up mysqld-max with the full functionality (without use -Sg option)? I was thinking that the origin of this problem was that I have not privilege tables on my PC. Please, can you help me? Thanks in advance José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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