I looked over the list of InnoDB options
You have one option that does not appear in the list of Startup Options : innodb
sysdate_is_now = 1
innodb = FORCE <---- No such option called innodb
innodb_strict_mode = 1
I think you meant innodb_force_recovery
instead. Before you use it, you need to know the values allowed it.
Here are the options from the MySQL Documentation on Forced Recovery
1 (SRV_FORCE_IGNORE_CORRUPT)
Let the server run even if it detects a corrupt page. Try to make
SELECT * FROM tbl_name jump over corrupt index records and pages,
which helps in dumping tables.
2 (SRV_FORCE_NO_BACKGROUND)
Prevent the master thread from running. If a crash would occur during
the purge operation, this recovery value prevents it.
3 (SRV_FORCE_NO_TRX_UNDO)
Do not run transaction rollbacks after crash recovery.
4 (SRV_FORCE_NO_IBUF_MERGE)
Prevent insert buffer merge operations. If they would cause a crash,
do not do them. Do not calculate table statistics.
5 (SRV_FORCE_NO_UNDO_LOG_SCAN)
Do not look at undo logs when starting the database: InnoDB treats
even incomplete transactions as committed.
6 (SRV_FORCE_NO_LOG_REDO)
Do not do the redo log roll-forward in connection with recovery.
With this value, you might not be able to do queries other than a
basic SELECT * FROM t, with no WHERE, ORDER BY, or other clauses. More
complex queries could encounter corrupted data structures and fail.
If corruption within the table data prevents you from dumping the
entire table contents, a query with an ORDER BY primary_key DESC
clause might be able to dump the portion of the table after the
corrupted part.
The database must not otherwise be used with any nonzero value of
innodb_force_recovery. As a safety
Try replacing those lines in my.ini
:
sysdate_is_now = 1
# SRV_FORCE_IGNORE_CORRUPT
innodb_force_recovery = 1
innodb_strict_mode = 1
and run
net stop mysql
net start mysql
Give it a Try !!!
UPDATE 2013-02-22 21:29 EDT
@Michael-sqlbot had just pointed out to me that innodb
is a MySQL 5.1-specific plugin option to force an all-or-nothing situation: If InnoDB plugin fails to start, mysqld just dies rather than use the built-in InnoDB.
Your solution would simply be to remove that line
sysdate_is_now = 1
innodb_strict_mode = 1
and then restart mysql with
net stop mysql
net start mysql
UPDATE 2013-02-23 08:36 EDT
You may have to resort to putting all DOS paths in double quotes
datadir = "C:\WebSerer\MySQL\data"
or
datadir = "C:/WebSerer/MySQL/data"
also remove the trailing slash
Please try it now...
Best Answer
If You open Windows Services and check the service properties, You will find something like this:
not enough to change datadir in my.ini file, need also point windows to run service with proper my.ini file