[EMAIL PROTECTED] wrote: >>Description: > Every time I restart the database engine it loses grant entries, and I have > to manually reenter them by hand. Why aren't there rows finding their > way to disk? >>How-To-Repeat: > Add some grants, restart the database. >>Fix: > I don't know of a fix. >>Submitter-Id: <submitter ID> >>Originator: Josef Karthauser >>Organization: > Littoralis Ltd >>MySQL support: [none | licence | email support | extended email support ] >>Synopsis: Database loses rows when the database is restarted. >>Severity: serious >>Priority: medium >>Category: mysql >>Class: sw-bug >>Release: mysql-4.1.1-alpha (FreeBSD port: mysql-server-4.1.1) >>Server: /usr/local/bin/mysqladmin Ver 8.40 Distrib 4.1.1-alpha, for >>portbld-freebsd5.2 on i386 > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > and you are welcome to modify and redistribute it under the GPL license > > Server version 4.1.1-alpha > Protocol version 10 > Connection Localhost via UNIX socket > UNIX socket /tmp/mysql.sock > Uptime: 8 days 16 hours 7 min 34 sec >
Doesn't MySQL server read privileges defined on the table level? If so, it's related to the known bug: http://bugs.mysql.com/bug.php?id=2546 -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]