Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. Re: Migrate information of AdressSpace (Bassett, Mark)
----------------------------------------------------------------------
Message: 1
Date: Mon, 10 Feb 2014 17:37:37 +0000
From: "Bassett, Mark" <[email protected]>
Subject: Re: [Netdot-users] Migrate information of AdressSpace
To: Jaime Rafael Cabrera Letona <[email protected]>
Cc: netdot-users <[email protected]>
Message-ID:
<b9afe1a22e5a614aac33fec49e4e157c0137e...@g4w3293.americas.hpqcorp.net>
Content-Type: text/plain; charset="utf-8"
Also, when you are re-importing data, you don?t want to use mysqldump.
You?d want mysql -u root -p netdot < netdot.sql
From: Jaime Rafael Cabrera Letona [mailto:[email protected]]
Sent: Monday, February 10, 2014 9:04 AM
To: Bassett, Mark
Cc: netdot-users
Subject: Re: [Netdot-users] Migrate information of AdressSpace
Thanks Mark, but I am interested in migrate only data, I tried to do that
unsuccessfully.
In the machine with netdot 0.9.10 version I did that:
# mysqldump -u root -p --databases netdot > netdot0.9.10.sql
I did copy file to another machine prepared with 1.0.5 netdot version, and I
did that:
# mysqldump -u root -p --databases netdot < netdot0.9.10.sql
And then show these errors:
-- MySQL dump 10.13 Distrib 5.5.35, for debian-linux-gnu (i686)
--
-- Host: localhost Database: netdot
-- ------------------------------------------------------
-- Server version 5.5.35-0+wheezy1
/*!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 */;
mysqldump: Error: 'Error on delete of '/tmp/#sql_79e_2.MYI' (Errcode: 1)' when
trying to dump tablespaces
--
-- Current Database: `netdot`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `netdot` /*!40100 DEFAULT CHARACTER
SET utf8 */;
USE `netdot`;
--
-- Table structure for table `accessright`
--
DROP TABLE IF EXISTS `accessright`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accessright` (
`access` varchar(128) NOT NULL,
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`object_class` varchar(128) NOT NULL,
`object_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
mysqldump: Couldn't execute 'show fields from `accessright`': Can't
create/write to file '/tmp/#sql_79e_0.MYI' (Errcode: 17) (1)
Any sugestions?
Thanks,
On Fri, Feb 7, 2014 at 9:50 PM, Bassett, Mark
<[email protected]<mailto:[email protected]>> wrote:
I migrated from 0.9.9 to 1.0.5 yesterday.
What you probably need to do is on the 0.9.10 server do a mysqldump of the
netdot db.
wget http://netdot.uoregon.edu/pub/dists/netdot-1.0.1.tar.gz
tar xvf netdot-1.0.1.tar.gz
cd netdot-1.0.1
make testdeps
#tried make installdeps, fails due to some old pinned versions, installing from
cpan direct works
perl -MCPAN -e install Net::IPTrie
sudo make upgrade
~database updates happen... slowww
cd netdot-1.0.5-rc1
sudo make upgrade
~database updates happen? sloww
That will get your database inline with 1.0.5.
Then you can do another mysqldump of the appropriate tables and copy that into
the new 1.0.5 server.
Then you can drop the database and restore your 0.9.10 version.
Although you could also just actually do the upgrades and have two 1.0.5 =)
From:
[email protected]<mailto:[email protected]>
[mailto:[email protected]<mailto:[email protected]>]
On Behalf Of Jaime Rafael Cabrera Letona
Sent: Friday, February 07, 2014 8:27 AM
To: netdot-users
Subject: [Netdot-users] Migrate information of AdressSpace
Hello.
How can I migrate only the adress space information?
I have 2 servers with 0.9.10 and 1.0.5 versions respectively.
Regards,
________________________________
[cid:[email protected]]
Jaime Rafael Cabrera Letona
Coordinador Redes y Comunicaciones
USAC
________________________________
No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2014.0.4259 / Virus Database: 3684/7056<tel:3684%2F7056> - Release
Date: 02/03/14
_______________________________________________
Netdot-users mailing list
[email protected]<mailto:[email protected]>
https://osl.uoregon.edu/mailman/listinfo/netdot-users
--
jaimeco :(|)
Lo que no se vive se pierde
http://www.facebook.com/filosofiausac
http://jaimecabrera.blogspot.com
http://arje.usac.edu.gt
________________________________
No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2014.0.4259 / Virus Database: 3697/7080 - Release Date: 02/10/14
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140210/81e46303/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 13272 bytes
Desc: image001.jpg
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140210/81e46303/attachment.jpg
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 63, Issue 7
*******************************************
