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
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?
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_debug>mysqld --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?
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
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?
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 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?
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