Hi Lucia.. 1- The answers might/will be depent on what type of installation you are planning to do. Will you compile source code, or install binaries, or , since you said you would be installing on Linux, will you install from RPMs?
2 - Yes , you need to do the installation as root . 3 - There is no special account to create InnoDB tables, but you need to make sure that your MySQL server supports InnoDB tables.. Once the server supports it, anyone who has privileges to create tables, can create InnoDB tables. To ensure that you will have InnoDB support right after installation, make sure to download mysql-version*MAX* files. The files with the "MAX" word in it come with InnoDB support if InnoDB is available for that platform, and in your case, for Linux, yes it is. 4 - Data files (the database/table files) are owned by mysql . 5 - If you download and install *MAX* binaries for Linux, you'll already have InnoDB support . 6 - Those are the really databases. Those are same as what you define as the database name after '@' in oracle. The most recommended book on MySQL is MySQL by Paul Dubois, see its web page: http://www.kitebird.com/mysql-book/ . As for the user group, don't restrict yourself to the area you are living in, this list is a global user list of MySQL :) Make sure to visit the following pages: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/I/n/Installing_binary.html http://www.mysql.com/doc/P/o/Post-installation.html Gurhan Ozen MCI WorldCom Quality Assurance Team [EMAIL PROTECTED] ph: 703-449-4754 Vnet: 228-4754 1-800-PAGE-MCI pin: 1927052 AIM: Greywolf1923 -----Original Message----- From: Lucia DeMeester [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 11:19 PM To: [EMAIL PROTECTED] Subject: MYSQL question - Urgent Importance: High I am an Oracle DBA and need to create a MYSQL database on Thursday. Can you answer my questions? (I have not had chance to read the manual yet. Just a quick search, I can not find my answer.) I plan to use InnoDB and I find it is quite similar to Oracle. However, in Oracle we install the software and create the instance and database as oracle but I can not find any place describe what user I should use to create mysql database. We use Linux. Questions: - Do I use root account to install the software? - What account do I use to create Innodb? - Who owns the data files? root or mysql - Any suggestion of the owner and group for the mysql files? - I think the process is to load the mysql software, then configure the Innodb. Once the Innodb is configured, when you mean startup or shutdown mysql server is this the same as shutdown the Innodb? - When I query show databases, it give me mysql, test1, test2. Are they really databases or they are like schema owners in Oracle and Innodb is like instance in Oracle. P.S. What is a good book to buy for the MYSQL database and any user group in the United States I can belong. Thanks very much. Lucia DeMeester New Media Merchants 858-882-8500 ext. 2314 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php