IPAM MYSQL Dump not able to Create

[sandeepypatil]

IPAM MYSQL Dump not able to Create

[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

[sandeepypatil]

i am able to take dump with below commands
mysqldump -u root -p --opt --all-databases --ignore-database=information_schema --ignore-database=mysql > may2024.sql

i have copied dump file to new server on redhad 8 phpipam 1.6

rename the file name MIGRATE.sql when i get in mysql i can see databases which i kept in but on installation page not able to get Automatic database migration

config.php copied from old server to new server & rapleced is there any way i can migrate my .sql dump to new server

[sandeepypatil]

i can able to access phpipam but i see below error

Your phpIPAM version is too old to be upgraded, at least version1.4is required for upgrade.

[GaryAllan]

Upgrade to v1.6

[sandeepypatil]

yes from 1.3 to 1.6 i am doing

[sandeepypatil]

[GaryAllan]

yes from 1.3 to 1.6 i am doing

Version 1.7 bumped the minimum supported upgrade version to 1.4.

You're trying to upgrade to v1.7 (master/development) code.

[sandeepypatil]

phpIPAM IP address management [v1.7.0] dbversion 41

[sandeepypatil]

do i need install phpipam 1.6 so i can get .sql database detected

[GaryAllan]

If you're migrating from anything older than 1.4 you need to upgrade to 1.6 as an intermediate step.

1.19->1.6->1.7+

[GaryAllan]

You can migrate 1.3 straight to 1.6

[sandeepypatil]

Thanks for suggestion i will downgrade my phpipam version 1.7 to 1.6 can you share latest steps .because we wanted install 1.6 only but might be in github clone link 1.7 get downloaded. if any steps by steps guide only for 1.6 kindly suggest

following i did earlier

phpipam 1.6:

• Copy config.php from old server;

• Download code from Github, checkout branch 1.6 and pull all required submodules:
  # cd /var/www/html/
  # git clone https://github.com/phpipam/phpipam.git .
  # git checkout -b 1.6 origin/1.6
  # git submodule update --init --recursive

• Move copied config.php to new server

• Follow everything as in https://phpipam.net/phpipam-installation-on-centos-7/ (except php/mysql etc installation), ignore 2.1 (git pull)