MySQL database (5.0) will not start up

[secondogitto]

The data is held in a single large file named ibdata1, and the file

seems to have grown too large. This database is held on a Windows 2003

Server. I need someone to tell me how to extract the data from the

large datafile without starting the database OR extend the allowed size

for the file on Windows so that I can start db.

Starting the db from a command window, I get:

>> CMD window >>
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'

(10061)
>>>>>>>>>>>>>>>>>

error file is found at bottom of file
C:\Program Files\MySQL\MySQL Server 5.0\data\PARADIGM.err
091024 15:33:24 InnoDB: Operating system error number 23 in a file

operation.
InnoDB: Some operating system error numbers are described at
InnoDB:

http://dev.mysql.com/doc/mysql/en/Op...ror_codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.

[gavynblack]

See below short guide for repairing MySQL databases after corruption… mysqlcheck -u root -p --auto-repair --check --optimize --all-databases You must supply the password when asked, Or you can run this one but it's not recommended because the password is written in clear text: mysqlcheck -u root --password=THEPASSWORD --auto-repair --check --optimize --all-databases Also you may visit couple helpful and different resources for solving mysql database issue. http://www.filerepairforum.com/forum...tabase-crashed - community has many helpful and easy to understand tips for mysql databases https://mysql.recoverytoolbox.com/ Recovery Toolbox for MySQL - software restores corrupted table, rows and etc of MySQL databases