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/O…
InnoDB: File name .\ibdata1
InnoDB: File operation call: ‘Windows aio’.
InnoDB: Cannot continue operation.
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.
https://social.msdn.microsoft.com/F…