> > I've quick-tested this on deleuze, and mysql immediately > > created additional files in the new datadir: > > > > ib_logfile0 > > ib_logfile1 > > ibdata1 > > mysql_upgrade.info > > > > Do the 0, 1 etc. mean mysql will create more files with higher > > numbers in there, or this is it? Maybe we could live with those > > four if mysql will not attempt to delete/recreate them at some > > point (or create new ones). > > I´m not sure if there will be files with higher numbers, but remember that > MySQL will create at least one database in this directory for user > information, etc. Perhaps these are related to this mysql function? I > guess the real test would be to log in as a user and try to create a new > database with a previously used name once the permissions are set so that > only mysql can write in datadir.
No, look. It doesn't matter what the files are used for, or whether mysql will create the 'mysql' db there. (Those are things that we can accomodate as part of initial setup). The thing is that we need to remove 'w' flag for mysql on datadir directory (or chown it to someone else, even better), so that mysql can't add or remove files in /path/to/DATADIR/ . That way, users could never drop a database, since mysql could not delete the database directory. So only important question is whether or not mysql will try to add new or remove some of the existing 4 files under /path/to/DATADIR/ . (We're not worried by the fact that mysql won't be able to even create the database because we perform that step manually, and not by invoking mysql's create database). Cya, -doc _______________________________________________ HCoop-SysAdmin mailing list [email protected] http://hcoop.net/cgi-bin/mailman/listinfo/hcoop-sysadmin
