<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'><font face="arial, helvetica, sans-serif"><span style="font-size: 10pt;">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.</span></font><br><br><font face="arial, helvetica, sans-serif"><span style="font-size: 10pt;">I'm running on 4.8.0 now (well, that IX).</span></font><br><br><font face="arial, helvetica, sans-serif"><span style="font-size: 10pt;">So far I've done:</span></font><br><br><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;">1. Do a clean install of IXP Manager on the new system, making a note of</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;">the new mysql password for accessing the database.</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;"><br></span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;">2. Make a copy of the database on the old system using mysqldump and</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;">restore this to the new system.</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;"><br></span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;">3. Copy over .env from the old system, but modify this to use the new</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;">mysql access password.</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;"><br></span></font></div><div><font face="arial, helvetica, sans-serif"><span style="font-size: 13.3333px;">4. Then run through the upgrade procedure on docs.ixpmanager.org.</span><br><br><br><span style="font-size: 13.3333px;">I'm about to embark upon:</span><br><br><div><span style="font-size: 13.3333px;">5. mrtg data files. How you time the migration here may also lead to</span></div><div><span style="font-size: 13.3333px;">gaps in graphs if you cannot model and complete it quickly.</span></div><div><span style="font-size: 13.3333px;"><br></span></div><div><span style="font-size: 13.3333px;">6. if you have been adding customer logos, copy over</span></div><div><span style="font-size: 13.3333px;">$IXPROOT/public/logos to the same place in the new server</span></div><div><span style="font-size: 13.3333px;"><br></span></div><div><span style="font-size: 13.3333px;">7. if you have adding attachments to patch panels, copy over</span></div><div><span style="font-size: 13.3333px;">$IXPROOT/storage/files to the same place in the new server</span></div></font></div><br><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt;"><span name="x"></span><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><span style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; display: inline ! important; float: none;">-----</span><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><span style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; display: inline ! important; float: none;">Mike Hammett</span><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><a href="http://www.ics-il.com/" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">Intelligent Computing Solutions</a><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><a href="https://www.facebook.com/ICSIL" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/fbicon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/fbicon.png"></a><a href="https://plus.google.com/+IntelligentComputingSolutionsDeKalb" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/googleicon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/googleicon.png"></a><a href="https://www.linkedin.com/company/intelligent-computing-solutions" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/linkedinicon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/linkedinicon.png"></a><a href="https://twitter.com/ICSIL" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/twittericon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/twittericon.png"></a><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><a href="http://www.midwest-ix.com/" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">Midwest Internet Exchange</a><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><a href="https://www.facebook.com/mdwestix" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/fbicon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/fbicon.png"></a><a href="https://www.linkedin.com/company/midwest-internet-exchange" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/linkedinicon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/linkedinicon.png"></a><a href="https://twitter.com/mdwestix" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/twittericon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/twittericon.png"></a><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><a href="http://www.thebrotherswisp.com/" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">The Brothers WISP</a><br style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><a href="https://www.facebook.com/thebrotherswisp" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/fbicon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/fbicon.png"></a><a href="https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg" style="font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><img src="http://www.ics-il.com/images/youtubeicon.png" style="border: 0pt none;" src="http://www.ics-il.com/images/youtubeicon.png"></a><span name="x"></span><br></div><hr id="zwchr" style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt;"><div style="color: rgb(0, 0, 0); font-family: Helvetica, Arial, sans-serif; font-size: 12pt; font-weight: normal; font-style: normal; text-decoration: none;"><b>From: </b>"Nick Hilliard" <nick@inex.ie><br><b>To: </b>"INEX IXP Manager Users Mailing List" <ixpmanager@inex.ie><br><b>Sent: </b>Sunday, September 9, 2018 5:55:25 PM<br><b>Subject: </b>Re: [ixpmanager] Migration<br><br>Mike Hammett wrote on 09/09/2018 18:32:<br>> I found some information in a thread back in February. Unfortunately, <br>> because the current state is broken, mysqldump can't complete because of <br>> schema differences. Also, because I started this process 25 days ago, my <br>> 10 days of backups don't help me get back to a not-upgraded database.<br>> <br>> mysqldump: Couldn't execute 'SHOW FIELDS FROM <br>> `view_vlaninterface_details_by_custid`': View <br>> 'ixpmanager.view_vlaninterface_details_by_custid' references invalid <br>> table(s) or column(s) or function(s) or definer/invoker of view lack <br>> rights to use them (1356)<br>> <br>> (ran mysqldump as the root mysql user)<br><br>Try this:<br><br>% mysql -u root -p ixpmanager < IXP-Manager/tools/sql/views.sql<br><br>This will reset the views that are causing the problems.<br><br>Nick<br>_______________________________________________<br>INEX IXP Manager mailing list<br>ixpmanager@inex.ie<br>Unsubscribe or change options here: https://www.inex.ie/mailman/listinfo/ixpmanager<br></div><br></div></body></html>