Disaster recovery

Tuesday 07 November 2006 7:32:59 am

From what I can tell the problem seems to be the ibdata1 file.

I guess this contains all the data as in, my recovered directory, its over 64mb but only 18 mb in the fresh install.

I've tried to simply copying the file across but this just stop mysql from restarting.

Does anybody know how to recover this,

Thanks.

Monday 13 November 2006 3:45:58 am

Well, I managed to get this sorted in the end so, as nobody seem to know the answer, I thought I would post it here in case folk need it in future.

1. Clean install of MySQL
2. Stop the service
3. Copy the data you have from your rescued data directory (you need innodb1)

You will now find that the service will no start, if it does you will be able to see the tables but not access the data.

You need to run the following command

mysqld --innodb_log_file_size=xxxxxxx --innodb_force_recovery=4

The log file size needs to be correct. Check the error logs if you do not know the size, it will tell you from previous attempts to restart the service.

Now the data is restored and you can access it you can do a mysql dump.

Now you have the dump you can restore it to your ezp db.

Hope that helps.

Monday 20 April 2009 1:05:49 pm

No Trees were Harmed in the Making of this Datacenter

It goes without saying that our datacenter is virtually paperless in operation and, whenever possible, communications happen electronically rather than via paper-based mail or fax systems.

Our Atlanta datacenter is made almost completely of concrete, even the floor tiles, and almost nothing burns. Very little wood of any kind has been used in the facility. GNAX uses water based sprinkler systems and fire extinguishers that do no harm to human beings or the surrounding environment.

Closing Thoughts

The green initiatives our modern datacenter has put in place are already yielding excellent savings in the energy realm and with the plans we have for 2009, the GNAX team is excited to see just how far we can take this efficiency challenge. This is the present reality of responsible data center management and the industry’s premier research organization, the Uptime Institute, has entitled their upcoming 4th Annual Research Symposium: Lean, Clean, & Green. We’ll be there April 13 to 16 in New York City and are looking forward to meeting our colleagues and learning more ways of keeping it green in our datacenter world.

About the Author and Company

The author, Jeff Hinkle, is President of Global Net Access (GNAX) and highly invested in green initiatives and the conservation of our planet’s resources. Jeff has a long and deep history in creative datacenter and networking solutions. The author can be reached for questions and comments at jhinkle@atlantanap.com.

About the company: Global Net Access (GNAX) is the parent company of two industry-leading business lines: Enterprise Level Co-Location and Dedicated Servers. The company is headquartered in Atlanta, Georgia and also has operations in Dallas, Texas. GNAX runs primary operations out of AtlantaNAP (www.atlantanap.com), which is host to numerous corporate and enterprise co-location clients. The company’s dedicated server line, NetDepot (www.netdepot.com), operates over 2000 dedicated servers for clients spanning the globe. The recent expansion to Dallas allows the company to better serve the high demand for colocation and dedicated server clients in the dynamic Texas market. For more information about green datacenter initiatives, as well as creative hosting and networking strategies, please visit www.gnax.net or call 404-230-9150.