mysql will not restore database
Hi Guys.
I am having a problem restoring a database. Server is Ubuntu 8.04.4 LTS. It appears to wig out at a certain point, when this happens the output on the screen shows; Quote:
Quote:
Quote:
It looks like I am out of memory? Why is this happening? The previous attempt at trying to do the restore hung at the same point, but I received emails from my Nagios monitoring server telling me that I was out of SWAP, not memory. I have since given the server 3 gigs of swap to test and have now gotten the same error as before, but no alerts warning me that I am out of swap space. I am using a virtual environment so I will try upping the ram to 4Gb to see if that makes any diff. It is currently set to 2Gb. Anyone have any ideas? |
Quote:
|
It looks as if after creating more swap space (now 3Gb) and upping the ram (now 4gb), the database restore completed successfully.
The production database only contains 2Gb of RAM. Mind you, it finished with; Quote:
I dont know how to explain this problem since our production database is fine, with only 2Gb of RAM, mind you, I don't think anyones ever needed to restore to that database. This does not bode well for ease of mind. Edit - I have assumed that one of the tables/objects/something in the database to be restored required more resources to load. Unless anyone can come up with anything better, haha. |
All times are GMT -5. The time now is 08:40 PM. |