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
(Jaime Rafael Cabrera Letona)
----------------------------------------------------------------------
Message: 1
Date: Mon, 10 Feb 2014 11:03:43 -0600
From: Jaime Rafael Cabrera Letona <[email protected]>
Subject: Re: [Netdot-users] Migrate information of AdressSpace
To: "Bassett, Mark" <[email protected]>
Cc: netdot-users <[email protected]>
Message-ID:
<CACSLA0FkSjvpDSAj=o8vsbay4g3skta3kogz2nrssxhy4od...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
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]>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]] *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,
>
>
> ------------------------------
>
>
> Jaime Rafael Cabrera Letona
> Coordinador Redes y Comunicaciones
> USAC
> ------------------------------
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2014.0.4259 / Virus Database: 3684/7056 - Release Date: 02/03/14
>
> _______________________________________________
> Netdot-users mailing list
> [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
<http://hfilosofia.blogspot.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140210/136573b8/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 13272 bytes
Desc: not available
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140210/136573b8/attachment.jpe
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 63, Issue 5
*******************************************
