[ixpmanager] Migration

[Mike Hammett]

I found some information in a thread back in February. Unfortunately, because the current state is broken, mysqldump can't complete because of schema differences. Also, because I started this process 25 days ago, my 10 days of backups don't help me get back to a not-upgraded database. 


mysqldump: Couldn't execute 'SHOW FIELDS FROM `view_vlaninterface_details_by_custid`': View 'ixpmanager.view_vlaninterface_details_by_custid' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356) 

(ran mysqldump as the root mysql user) 



----- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 

----- Original Message -----

From: "Mike Hammett" <ixp-manager at ics-il.net> 
To: "INEX IXP Manager Users Mailing List" <ixpmanager at inex.ie> 
Sent: Thursday, September 6, 2018 3:36:28 PM 
Subject: [ixpmanager] Migration 


What's involved in migration of IXP Manager data from one server to another? I seem to be at an impasse in my upgrade from 4.7.x to 4.8.0 and am considering doing a fresh install and moving data over. 




----- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 


_______________________________________________ 
INEX IXP Manager mailing list 
ixpmanager at inex.ie 
Unsubscribe or change options here: https://www.inex.ie/mailman/listinfo/ixpmanager 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20180909/a4ad7859/attachment.html>