LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-30-2012, 05:09 AM   #1
Sharath Ravi
Member
 
Registered: Jun 2012
Posts: 37

Rep: Reputation: Disabled
Mysql error


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
 
Old 10-30-2012, 05:33 AM   #2
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
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.

Last edited by Wim Sturkenboom; 10-30-2012 at 05:35 AM.
 
Old 10-30-2012, 05:35 AM   #3
Sharath Ravi
Member
 
Registered: Jun 2012
Posts: 37

Original Poster
Rep: Reputation: Disabled
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
 
Old 10-30-2012, 11:07 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,933

Rep: Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692
Quote:
Originally Posted by Sharath Ravi View Post
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 02:52 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM


All times are GMT -5. The time now is 06:29 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration