IPAM MYSQL Dump not able to Create

[sandeepypatil]

Hi Team ,

we are Migrating IPAM from 1.3 to 1.6 (OS Redhat 6 to Redhat 8.8)

On Redhat 6 Our Current phpIPAM is live .& also Install phpIPAM 1.6 on New server Redhat8.8

i dont know root password to take msql dump which needed to copy to new phpIPAM.is there any other way we can create dump or migarte to new phpIPAM .this is more into MYSQL dump related.I Tried to reset root password but no luck .can any one help me on this.

below are info for current live server
PHP 7.0.24 (cli) (built: Sep 30 2017 10:49:25) ( NTS )
PHPIPAM 1.3
REDHAT OS 6
Server version: 5.7.19-log MySQL Community Server (GPL)

[GaryAllan]

From the web GUI.

Administration->Import / Export, Prepare Mysql dump

[sandeepypatil]

Thanks for reply i have tried on GUI i got 2kb file .sql in my download folder. does that dump auto saved in server itself in any directory ?????

below is file content

phpipam Database dump

command executed: mysqldump --opt -h 'localhost' -u '' -p'' 'phpipam'

---------------------

-- MySQL dump 10.13 Distrib 5.7.19, for Linux (x86_64)

-- Host: localhost Database: phpipam

---

-- Server version 5.7.19-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8 /;
/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
/!40103 SET TIME_ZONE='+00:00' /;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Temporary table structure for view IP Record Changes - Past 30 days

DROP TABLE IF EXISTS IP Record Changes - Past 30 days;
/!50001 DROP VIEW IF EXISTS IP Record Changes - Past 30 days/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/!50001 CREATE VIEW IP Record Changes - Past 30 days AS SELECT
1 AS Change Date,
1 AS User,
1 AS IP Address,
1 AS DNS Name/;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view Proxy

DROP TABLE IF EXISTS Proxy;

[GaryAllan]

does that dump auto saved in server itself in any directory ?????

No. Downloaded only to your PC.

[sandeepypatil]

I am trying to take a dump below are the error
[root@XXXXX ~]#
[root@XXXXX ~]# mysqldump -u root -p --opt --all-databases > may2024.sql
Enter password:
mysqldump: Couldn't execute 'SHOW FIELDS FROM Proxy': View 'phpipam.Proxy' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
[root@XXXXX ~]#

is there workaround i can create dump in .sql Format which i can migrate on Latest phpipam Version
Thanks in advance

[GaryAllan]

Via the web GUI. Administration -> import export -> prepare MySQL dump