Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Administrators

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-23-2009, 07:52 AM
Senior Member
 
Posts: 50
Default [SOLVED] Mysql Error 2002 when restoring

Using 5.0.12.

I moved all my stuff over to a vm server running Ubuntu 8.04 server, so I could upgrade from Ubuntu 7.10 full to 8.04 server.

Everything seemed to be running fine until I tried to do a cold backup using the lvm backup script, and it crashed out, however the server was still running, but it seemed there may be some bad sectors.

The process is:
Install zimbra using -s
copy the old zimbra directory over (I've tried tarring, rsync, and copy).

Then I re-install zimbra for it to "upgrade". When I tell it I want to check message store, it takes a while then spits out
"/opt/zimbra/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2) when trying to connect".

If I continue the "upgrade", it fails at starting mysqld.

I've tried using an older backup, but that is still showing the same errors.

And now, the vm server is telling me the mysql server is not running (It restarted with a cold backup), so I am kinda without an email server right now. Any help would be appreciated.

Solved:

I had searched the forums, but apparently my keywords were wrong. I found another thread that talked about it. I instead did a full install, then moved the directory, then used a backup from earlier this morning, and it finally worked. I'm thinking it was the full vanilla install that finally fixed it, I had just done the -s install previously.

Last edited by Cryophallion; 02-23-2009 at 11:40 AM.. Reason: Solved
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com




 

SEO by vBSEO ©2011, Crawlability, Inc.