[racktables-users] Re: bulk upload ???
- From: "Dahlstrom, Kishore M. (LNG-SEA)" <kishore.dahlstrom@xxxxxxxxxxxxxxxxxxxx>
- To: <racktables-users@xxxxxxxxxxxxx>
- Date: Wed, 30 Sep 2009 13:03:48 -0700
To be honest, I did screw up the DB but, I did have a backup which I was
able to recover. It is easy to add but modifying the objects in the
table once there are relationships is where things can go sideways. The
only table I am able to modify successfully is the RackObject table.
The other tables seem Greek to me.
Future reference to my issue:
For some reason the File and the Filelink tables got corrupted when I
was importing the RackObject table. It did not make any sense to me why
those two tables got corrupted. With help from one of the Racktable
users, I was able to check each table and figure out which ones were
corrupted. These two table being corrupted caused some of the links to
break and also search did not work at all. I had to restore from backup
to fix my issue. Then I exported the RackObject table made the
modification and added additional items and imported back and it worked
great with no corruptions.
I am going to the smart thing and hand the racktables database support
to our DBAs.
From: racktables-users-bounce@xxxxxxxxxxxxx
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Rob
Sent: Wednesday, September 30, 2009 11:38 AM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Re: bulk upload ???
Yea ... I was doing the same with phpMyAdmin .... but it seems a bit
brute force and doesn;t take into account all the relationships like
ports ... IPs ... etc ...
I figure, left on my own I could screw up the database royally .....
:-)
On Wed, Sep 30, 2009 at 6:16 PM, Dahlstrom, Kishore M. (LNG-SEA)
<kishore.dahlstrom@xxxxxxxxxxxxxxxxxxxx> wrote:
I exported the RackObject tables and modified it and then I imported the
table using Navicat. You can also use webmin or other mysql tools.
From: racktables-users-bounce@xxxxxxxxxxxxx
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Rob
Sent: Wednesday, September 30, 2009 11:00 AM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] bulk upload ???
Has anyone came up with a good method for bulk uploading ??? Given I
have a bunch of spreadsheets with all my assets .. that I can export in
almost any possible format .... looking for an easy way to pump that all
in without going through the UI ....
Other related posts:
