Re: innodb is disabled, how can i make it yes?
Hytham, - Original Message - From: Hytham Shehab [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 6:21 AM Subject: Re: innodb is disabled, how can i make it yes? hi Heikki, i do what u said: yourpathtomysqlbindir mysqld-max-nt --console cannot initialize innodb as 'innodb_data_file_path' is not set ... i sword in god that i have set this data file path as: innodb_data_file_path=c:/mysql/data/ibdata:300M and this is a valid directory, and some times i get another error message: os error number 123 in a file operation ???!!! have you added the line to the [mysqld] section in my.cnf? my.cnf should look like this: [mysqld] innodb_data_home_dir= innodb_data_file_path=c:/mysql/data/ibdata:300M Also, if you do not specify innodb_data_home_dir, it gets the datadir of MySQL as the default. Then you cannot give the absolute file path to the ibdata file like you have done above. In this case MySQL-Max-3.23.51 and 4.0.2 print: C:\m\client_debugmysqld --console 020703 11:40:04 InnoDB: Operating system error number 123 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: Look from section 13.2 at http://www.innodb.com/ibman.html InnoDB: what the error number means. InnoDB: File name .\c:\mysql\data\ibdata InnoDB: Cannot continue operation. From http://www.innodb.com/ibman.html#OS_Error_codes we see: 123 The filename, directory name, or volume label syntax is incorrect. ERROR_INVALID_NAME thanks -- Hytham Shehab Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.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
RE: innodb is disabled, how can i make it yes?
Are you sure that you are starting mysqld-max-nt.exe for the server ? If so, try mysqld-max-nt --print-defaults to see what parameters are set, maybe that will give you a clue ... CB. -Original Message- From: Hytham Shehab [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 00:19 To: Paul DuBois Cc: [EMAIL PROTECTED] Subject: Re: innodb is disabled, how can i make it yes? hi Paul: Make sure it's not being started with --skip-innodb. i am sure that the --skip-innodb is not in any of my configuration files. sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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
Re: innodb is disabled, how can i make it yes?
at last, i got an error 5 'Access Denied', then after some blah,blah, etc, etc, it got started with InnoDB. not InnoDB is yes. now i can write a good SQL QUERY ;) special thanks to Heikki and Bert -- Hytham Shehab - 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
innodb is disabled, how can i make it yes?
hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the client, i type: show variables like have_%; --- variable_name | value --- have_bdb| yes have_innodb| disabled have_openssl | no ... --- why the innodb is disabled ? thanks in advance sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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
Re: innodb is disabled, how can i make it yes?
At 23:52 +0300 7/2/02, Hytham Shehab wrote: hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the client, i type: show variables like have_%; --- variable_name | value --- have_bdb| yes have_innodb| disabled have_openssl | no ... --- why the innodb is disabled ? Make sure it's not being started with --skip-innodb. thanks in advance sql -- Hytham Shehab - 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
Fw: innodb is disabled, how can i make it yes?
hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the client, i type: show variables like have_%; --- variable_name | value --- have_bdb| yes have_innodb| disabled have_openssl | no ... --- why the innodb is disabled ? thanks in advance sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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
Re: innodb is disabled, how can i make it yes?
hi Paul: Make sure it's not being started with --skip-innodb. i am sure that the --skip-innodb is not in any of my configuration files. sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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
Re: innodb is disabled, how can i make it yes?
Hytham, start mysqld-max-nt from the MS-DOS prompt: yourpathtomysqlbindir mysqld-max-nt --console What does InnoDB print? Regards, Heikki - Original Message - From: Hytham Shehab [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 2:24 AM Subject: Re: innodb is disabled, how can i make it yes? hi Paul: Make sure it's not being started with --skip-innodb. i am sure that the --skip-innodb is not in any of my configuration files. sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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
Re: innodb is disabled, how can i make it yes?
hi Heikki, i do what u said: yourpathtomysqlbindir mysqld-max-nt --console cannot initialize innodb as 'innodb_data_file_path' is not set ... i sword in god that i have set this data file path as: innodb_data_file_path=c:/mysql/data/ibdata:300M and this is a valid directory, and some times i get another error message: os error number 123 in a file operation ???!!! thanks -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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
Re: innodb is disabled, how can i make it yes?
hi Heikki, i do what u said: yourpathtomysqlbindir mysqld-max-nt --console cannot initialize innodb as 'innodb_data_file_path' is not set ... i sword in god that i have set this data file path as: innodb_data_file_path=c:/mysql/data/ibdata:300M and this is a valid directory, and some times i get another error message: os error number 123 in a file operation ???!!! thanks -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2005 - 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
