In news:[EMAIL PROTECTED], [EMAIL PROTECTED] <[EMAIL PROTECTED]> typed:
> After creating a new mysql db from the script, should I have first > restored the old mysql database, then the user databases? You should first restore mysql database just to be on the safe side, but I don't think the import of other databases would fail if you did otherwise. > 2. Somewhere I saw that I still needed to create the InnoDB shared > tablespace. What does InnoDB use this for? For the production > system, I need to estimate what size to start with. InnoDB stores there some internal structures and undo logs. Unless there are large or lenghty transactions performed in your database, you shouldn't need much space for the shared tablespace. You may also consider allowing this tablespace to extend automatically if more space is required, which is generally a good idea. > 3. I restored the original mysql database as mysql_old, so I have > access to the old grant tables. Any suggestions for how to recover > the user permissions without redoing all the steps? The simplest solution is to stop the database, remove the contents of datadir/mysql directory and move there all the files from datadir/mysql_old (or copy preserving owner/group/permissions). Then start the server agin. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
