 Constraints Don't Work In Mysql? |
Free Web Hosting > Computers & Tech > Programming > Programming General > SQL (Structured Query Language)|
|
|
|
  |
 Jan 1 2008, 01:21 PM
Post
#11
|
|
|
Premium Member  Group: [HOSTED] Posts: 372 Joined: 16-February 06 From: Kolkata, India Member No.: 11,322  |
Yes, I am using XAMPP. The "SHOW ENGINES;" statement shows InnoDB as disabled. Perhaps enabling it requires some INI file configuration?
Edit: Found the way to enable InnoDB in http://www.mydigitallife.info/2006/10/21/e...p-installation/ It all works out nicely now. Thanx for your help. This post has been edited by turbopowerdmaxsteel: Jan 1 2008, 01:34 PM |
 |
 
|
|
Jan 1 2008, 01:34 PM
Post
#12
|
|
|
Member [ Level 1 ]  Group: Members Posts: 30 Joined: 31-December 07 Member No.: 27,267 |
Edit: I'm truly glad that it works for you now. Have fun with InnoDB! If you do not need transactional engines though, do consider using MyISAM with constraints enabled. This feature is available in the more recent MySQL versions.
--------------- That would most likely be the issue. Please see your my.cnf file which contains MySQL's configuration. There would be a line there with the text "skip-innodb". This line should be commented-out. After that, there are lines that are required to be UNcommented; you will find that the configuration file is quite well-documented and very understandable. It will point to you lines that must be modified to enable InnoDB. For example, change: QUOTE - Comment the following line to unskip and use InnoDB skip-innodb - Uncomment the following options for InnoDB database if you are using InnoDB tables. #innodb_data_home_dir = C:/xampp/xampp/mysql/data/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = C:/xampp/xampp/mysql/data/ #innodb_log_arch_dir = C:/xampp/xampp/mysql/data/ - Uncomment the lines and set innodb_buffer_pool_size up to 50% - 80% of RAM for optimization of InnoDB databases, try not to memory usage too high. #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M - Uncomment the lines and set innodb_log_file_size to 25% of InnoDB buffer pool size for optimisation. #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #set-variable = innodb_lock_wait_timeout=50 To: QUOTE #skip-innodb innodb_data_home_dir = C:/xampp/xampp/mysql/data/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = C:/xampp/xampp/mysql/data/ innodb_log_arch_dir = C:/xampp/xampp/mysql/data/ set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50 Do not copy-paste this though, check with your actual documentation. In case this has been done and InnoDB still is not active, you may need to use a non-reduced version of MySQL taken from the actual official site. This post has been edited by altimit: Jan 1 2008, 01:41 PM |
|
|
|
|
Similar Topics
| Topics | Topics | |
|---|---|---|
|
|
|
|
Lo-Fi Version | Time is now: 6th September 2008 - 05:35 PM |