[ixpmanager] Migration

[Mike Hammett]

Yup. I got interrupted in the process, so I didn't get to report back. I later saw the part to reset the views, so no harm done. 

I'm running on 4.8.0 now (well, that IX). 

So far I've done: 


1. Do a clean install of IXP Manager on the new system, making a note of 
the new mysql password for accessing the database. 


2. Make a copy of the database on the old system using mysqldump and 
restore this to the new system. 


3. Copy over .env from the old system, but modify this to use the new 
mysql access password. 


4. Then run through the upgrade procedure on docs.ixpmanager.org. 


I'm about to embark upon: 


5. mrtg data files. How you time the migration here may also lead to 
gaps in graphs if you cannot model and complete it quickly. 


6. if you have been adding customer logos, copy over 
$IXPROOT/public/logos to the same place in the new server 


7. if you have adding attachments to patch panels, copy over 
$IXPROOT/storage/files to the same place in the new server 



----- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 

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

From: "Nick Hilliard" <nick at inex.ie> 
To: "INEX IXP Manager Users Mailing List" <ixpmanager at inex.ie> 
Sent: Sunday, September 9, 2018 5:55:25 PM 
Subject: Re: [ixpmanager] Migration 

Mike Hammett wrote on 09/09/2018 18:32: 
> 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) 

Try this: 

% mysql -u root -p ixpmanager < IXP-Manager/tools/sql/views.sql 

This will reset the views that are causing the problems. 

Nick 
_______________________________________________ 
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/3a04f0e4/attachment.html>