Hello.
Have you ran mysql_init_db on a new data directory? > store the tables that store grants and such, but how to we get those > created for the new instance. We've been all over the MySQL.com docs It is unclear for me. You may specify the datadir for every new instance. See: http://dev.mysql.com/doc/mysql/en/mysqld-multi.html Don Vaillancourt <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: ISO-8859-1, 55 lines --] > > We have MySQL setup as a MYSQL_MULTI configuration so that each database > has their own instance of MySQL. > > We need another database configured and so added an entry in the my.cnf. > > We've tried to start the new database, but keep getting this error. We > know that for each database there needs to be a mysql sub-folder to > store the tables that store grants and such, but how to we get those > created for the new instance. We've been all over the MySQL.com docs > and can't find the solution. Anyone have any ideas? > > Thanks > > > 050423 12:07:20 mysqld started > 050423 12:07:20 [Warning] Asked for 196608 thread stack, but got 126976 > 050423 12:07:20 InnoDB: Database was not shut down normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the doublewrite > InnoDB: buffer... > 050423 12:07:20 InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 0 43634. > InnoDB: Doing recovery: scanned up to log sequence number 0 43634 > 050423 12:07:20 InnoDB: Flushing modified pages from the buffer pool... > 050423 12:07:20 InnoDB: Started; log sequence number 0 43634 > 050423 12:07:20 [ERROR] Fatal error: Can't open privilege tables: Table > 'mysql.host' doesn't exist > 050423 12:07:20 mysqld ended > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]