Hi! I'm new to MySQL and I´m trying to understand how Innodb works. So far I have set up the InnoDB data files and directories and have MySQL up and running. I set my "my.ini" file with the following:
# Uncomment the following if you are using Innobase tables innodb_data_home_dir= innodb_data_file_path = D:/Program Files/MySQL/data/ibdata1:10M:autoextend innodb_log_group_home_dir = D:/Program Files/MySQL/iblogs innodb_log_arch_dir = D:/Program Files/MySQL/iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 1 - Everything works perfectly... But I am not understanding InnoDB. The database ibdata was created, but I would like to create a database with other name and not Ğibdatağ... I haven't found a good FAQ for explaining this... 2 - WHat about that ibdata1 I created? I am assuming that this is my database where transactional tables will be created... But what should I do if I want to create another database, with another name and Innodb tables too? Should I keep my.ini with that configuration? Or Should I change the ibdata to another name? 3 - I just feel like I am missing something. If anyone can explain to me about what exactly is going on with this I would be grateful. I have been to the Innodb.com site. Great tutorial, but It leaves me with lots of questions... So please, don´t send me links please..... Best Regards to all, Janine __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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
