Hey list,
I too had problems with a single database that didn't restore correct..
A rather large one (a few mb's) that was in a single line in the
backupfile that was suggested in the guide. After I removed that line
from the guide, the databases restored correctly and I had no other
problems upgrading mysqld.
So now I'm running two mysqld's - one for the db that didn't restore,
and one for all the others. Just untill I , or someone else , find out
how to do this so it works.
Just my .02,
/Jakob Rosenlund
Covington, Chris wrote:
all you need to do is the follow step by step what's written
here : http://www.gentoo.org/doc/en/mysql-upgrading.xml
I followed that and I wasn't able to restore my backup. Specifically,
the snort database was screwed up:
frank2k3 ccovington # cat BACKUP_MYSQL_4.0.SQL | mysql -uroot
-hlocalhost --max_allowed_packet=16M
ERROR 1005 (HY000) at line 1813: Can't create table './snort/data.frm'
(errno: 150)
So I'm still using 4.0.25
---
Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com
--
[email protected] mailing list
