Re: MYSQL Fresh Reinstall, How?
Yeah I ran into that yesterday myself. The mysql_install_db doesnt leave you with a working mysql database lately. What did to fix it was mysqld -u mysql --skip-grant (Im assuming you have your mysql firewalled off, if not do that first ;) At that point mysql is up enough to restore the mysql database. I ran msyql mysql mysql.sql where mysql.sql was made from mysqldump of a working mysql. Then mysqladmin shutdown. Then your fine after that for normal operations. I am using innodb as the default table type. I dont know if you are or if that matters. On Fri, 29 Aug 2003 02:52:56 -0400, Ben Dover [EMAIL PROTECTED] said: I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it straightened out. I think the best way to resolve this would be to do a fresh install of MYSQL server. I did a pkg_delete of MYSQL-server and client and installed again from ports but I'm getting the same error messages. Is there a way to just start out fresh like I never had MYSQL installed in the first place? The error I'm getting is: 030829 2:36:36 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030829 02:36:36 mysqld ended This started out from something I did while trying to get Plesk6 to work on 5.1 (which I did) but without MYSQL working I uninstalled Plesk6. I think what I did was delete the database mysql and I guess it is essential. Any assistance would be appreciated but I'm leaning toward a fresh install if possible. _ MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MYSQL Fresh Reinstall, How?
On Fri, Aug 29, 2003 at 02:52:56AM -0400, Ben Dover wrote: I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it straightened out. I think the best way to resolve this would be to do a fresh install of MYSQL server. I did a pkg_delete of MYSQL-server and client and installed again from ports but I'm getting the same error messages. Is there a way to just start out fresh like I never had MYSQL installed in the first place? The error I'm getting is: 030829 2:36:36 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030829 02:36:36 mysqld ended As the previous poster said you should first try restoring your mysql tables (the mysql database particularly '/var/db/mysql/' and it's children since it's the host.frm db file that's screwing up). If you're not too bothered about losing the data in your mysql db then you can just simply move the mysql db files totally: mv /var/db/mysql /var/db/mysql.bak and then reinstall from scratch (deinstall first if you haven't already, it'll complain but should succeed). You could then copy across the dbs from /var/db/mysql.bak back into /var/db/mysql after the reinstall and then recreate the mysql users with appropriate privs on the dbs. I _think_ this could work, but would be a pain. The best thing to do would be to just restore your mysql db from backup - you have those right!? (This was about the time when _I_ started to do backups regularly after having a similar problem:) -- Jez http://www.munk.nu/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MYSQL Fresh Reinstall, How?
If you rm -rf /var/db/msyql then reinstall it doesnt work right now is the problem... at least on freebsd. It gives the host.frm error the poster asked about. Ive only been able to get a new system going by restoring the mysql database (/var/db/mysql/mysql) from elsewhere. On Fri, 29 Aug 2003 09:33:16 +0100, Jez Hancock [EMAIL PROTECTED] said: On Fri, Aug 29, 2003 at 02:52:56AM -0400, Ben Dover wrote: I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it straightened out. I think the best way to resolve this would be to do a fresh install of MYSQL server. I did a pkg_delete of MYSQL-server and client and installed again from ports but I'm getting the same error messages. Is there a way to just start out fresh like I never had MYSQL installed in the first place? The error I'm getting is: 030829 2:36:36 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030829 02:36:36 mysqld ended As the previous poster said you should first try restoring your mysql tables (the mysql database particularly '/var/db/mysql/' and it's children since it's the host.frm db file that's screwing up). If you're not too bothered about losing the data in your mysql db then you can just simply move the mysql db files totally: mv /var/db/mysql /var/db/mysql.bak and then reinstall from scratch (deinstall first if you haven't already, it'll complain but should succeed). You could then copy across the dbs from /var/db/mysql.bak back into /var/db/mysql after the reinstall and then recreate the mysql users with appropriate privs on the dbs. I _think_ this could work, but would be a pain. The best thing to do would be to just restore your mysql db from backup - you have those right!? (This was about the time when _I_ started to do backups regularly after having a similar problem:) -- Jez http://www.munk.nu/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MYSQL Fresh Reinstall, How?
On Fri, Aug 29, 2003 at 03:04:07AM -0600, Aaron Wohl wrote: If you rm -rf /var/db/msyql then reinstall it doesnt work right now is the problem... at least on freebsd. It gives the host.frm error the poster asked about. Ive only been able to get a new system going by restoring the mysql database (/var/db/mysql/mysql) from elsewhere. You mean the port is broken? Ick :( Try and fix it and submit a patch? :) I suppose that's the risk of running unstable software (relatively speaking). -- Jez http://www.munk.nu/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MYSQL Fresh Reinstall, How?
At 02:52 AM 8.29.2003 -0400, Ben Dover wrote: I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it straightened out. I think the best way to resolve this would be to do a fresh install of MYSQL server. I did a pkg_delete of MYSQL-server and client and installed again from ports but I'm getting the same error messages. Is there a way to just start out fresh like I never had MYSQL installed in the first place? The error I'm getting is: 030829 2:36:36 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030829 02:36:36 mysqld ended This started out from something I did while trying to get Plesk6 to work on 5.1 (which I did) but without MYSQL working I uninstalled Plesk6. I think what I did was delete the database mysql and I guess it is essential. Any assistance would be appreciated but I'm leaning toward a fresh install if possible. If you can use portugrade, it was always a simple one-line command on FBSD-4.x: # portupgrade -m '-DSKIP_INSTALL_DB' mysql-server-3.xx.xx The above preserves the databases just fine. Haven't tried it on 5.1 though Best regards, Jack L. Stone, Administrator SageOne Net http://www.sage-one.net [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MYSQL Fresh Reinstall, How?
I just don't understand what your talking about. When I start mysql I get the following below error so I guess its not running enough to do what your talking about? Could you please explain a little more in detail where I would type that command if it is a command. Thanks From: Aaron Wohl [EMAIL PROTECTED] To: Ben Dover [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: MYSQL Fresh Reinstall, How? Date: Fri, 29 Aug 2003 02:22:08 -0600 Yeah I ran into that yesterday myself. The mysql_install_db doesnt leave you with a working mysql database lately. What did to fix it was mysqld -u mysql --skip-grant (Im assuming you have your mysql firewalled off, if not do that first ;) At that point mysql is up enough to restore the mysql database. I ran msyql mysql mysql.sql where mysql.sql was made from mysqldump of a working mysql. Then mysqladmin shutdown. Then your fine after that for normal operations. I am using innodb as the default table type. I dont know if you are or if that matters. On Fri, 29 Aug 2003 02:52:56 -0400, Ben Dover [EMAIL PROTECTED] said: I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it straightened out. I think the best way to resolve this would be to do a fresh install of MYSQL server. I did a pkg_delete of MYSQL-server and client and installed again from ports but I'm getting the same error messages. Is there a way to just start out fresh like I never had MYSQL installed in the first place? The error I'm getting is: 030829 2:36:36 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030829 02:36:36 mysqld ended This started out from something I did while trying to get Plesk6 to work on 5.1 (which I did) but without MYSQL working I uninstalled Plesk6. I think what I did was delete the database mysql and I guess it is essential. Any assistance would be appreciated but I'm leaning toward a fresh install if possible. _ MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] _ Get MSN 8 and enjoy automatic e-mail virus protection. http://join.msn.com/?page=features/virus ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]