Mysql error

Sharath Ravi · 10-30-2012, 04:09 AM

hi,

I am getting an error in mysql while restoring db through windows onto centos server..

mysql.exe: Out of memory (Needed 1073741825 bytes)
mysql.exe: Error reading file 'UNOPENED' (Errcode: 22)

Can someone help me on this.

Thanks

Wim Sturkenboom · 10-30-2012, 04:33 AM

Please provide the exact command that you're using. It will help people to help you

How was the backup created? How big is the file? You might have to split it.

Sharath Ravi · 10-30-2012, 04:35 AM

Hi,

This is the command issed

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe -u root -p -h172.16.0.69 -
P 3307 < "F:\Backup\Prod\prodback.db"

0.69 is a centos machine.

prodback is 6.63 GB

Sorry

TB0ne · 10-30-2012, 10:07 AM

Quote:

Originally Posted by Sharath Ravi

Hi,
This is the command issed

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe -u root -p -h172.16.0.69 -P 3307 < "F:\Backup\Prod\prodback.db"

0.69 is a centos machine. prodback is 6.63 GB

Did you try looking on the MySQL forums first?? The error code and error message are telling.
http://dev.mysql.com/doc/refman/5.0/...e-handles.html

You can adjust some parameters (SET GLOBAL table_open_cache and SET GLOBAL max_connections) in your my.cnf file to be lower, then restart the database. Also, the error 22 indicates that the file isn't there or you don't have permissions to read it. And you appear to be running this on a Windows machine...why? You can copy the file to the Linux system, and import it directly, and not have to deal with Windows limitations.