store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Tue Oct 15, 2019 10:40 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Plesk backup / mysql_dump issues after upgrade to 5.538
Unread postPosted: Mon Jul 28, 2014 11:44 am 
Offline
Forum User
Forum User

Joined: Sat Jul 07, 2012 11:33 pm
Posts: 5
Location: Dallas, Texas
Hi all. I'm running Plesk 11.5.30 on a dedicated (and newly configured) Cent OS 6.5 box. I've just migrated about 30 web sites from an older server, which was running Plesk 9.5.4. All software on the new server is up to date, to my knowledge. I recently upgraded to MySql 5.5.38 using the Atomic repo, and I'm getting the following errors backing up through Plesk panel, and doing mysql dumps using automysqlbackup.

Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = (databasename) Cannot load from mysql.proc. The table is probably corrupted (1548)

According to Plesk ( http://kb.parallels.com/121164 ) - i can run mysql_upgrade and it will magically fix everything. Since this is on a running production server with about 30 sites on it, I'm a little paranoid. Does anyone have any direct experience with this upgrade? Are there any potential pitfalls / issues / incompatibilities?

Also, I've already run 'mysqlcheck --all-databases --check-upgrade' and output indicates that all of my tables are OK. So what gives?

Thanks in advance -
Scott


Top
 Profile  
Reply with quote  
 Post subject: Re: Plesk backup / mysql_dump issues after upgrade to 5.538
Unread postPosted: Mon Jul 28, 2014 12:00 pm 
Offline
Forum Regular
Forum Regular

Joined: Tue Aug 01, 2006 2:45 pm
Posts: 573
Location: Netherlands
From which MySQL version did you upgrade?

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
Reply with quote  
 Post subject: Re: Plesk backup / mysql_dump issues after upgrade to 5.538
Unread postPosted: Fri Aug 08, 2014 11:42 am 
Offline
Forum User
Forum User

Joined: Sat Jul 07, 2012 11:33 pm
Posts: 5
Location: Dallas, Texas
Per Yum logs, it looks as if my original MySql version was mysql-5.1.73-3.el6_5.x86_64. FYI - this is only happening with some tables. According to this Plesk article, http://kb.parallels.com/121164 , I need to run mysql_upgrade. However, I'm a little concerned about doing this on a production server. Any advice or other recommendations appreciated. Thanks for your reply.


Top
 Profile  
Reply with quote  
 Post subject: Re: Plesk backup / mysql_dump issues after upgrade to 5.538
Unread postPosted: Sat Aug 09, 2014 10:32 am 
Offline
Forum Regular
Forum Regular

Joined: Tue Aug 01, 2006 2:45 pm
Posts: 573
Location: Netherlands
You need to run "mysql_upgrade" when upgrading from 5.1 to 5.5.

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group