Reload question

[Isaac W Traxler]

I have discovered that the data I have in racktables is not consistent. In
particular rows do not show up in the rack view that cna be found by
searching for things in that row. I believe that the problem is related to
an upgrade in the past that had issues.

Question: Is there a way to dump data out and then load into a fresh
install? I am not worried about 100% conversion, but 80% would svae an
incredible amount of time.

Suggestions?

--
Isaac Traxler AIX,Linux Admin
Louisiana State University, LONI traxler-AGZSo6uS0+***@public.gmane.org
High Performance Computing 225-578-1923
Storage & Infrastructure

[Matthew Castanien]

Are you looking for a database dump? If so use mysqldump. Example steps below.


Take backup.

mysqldump -u racktables-db-owner -p racktables-db-name > /tmp/racktables_db_YYYYMMDD_HHMMSS.sql

Go to machine with fresh install and create blank DB.

mysql> create database racktables;

Import data into blank DB.

mysql -u racktables-db-owner -p racktables-db-name < /tmp/racktables_db_YYYYMMDD_HHMMSS.sql

Point fresh install at this database and hit URL.


I'm curious to know if the issues you are seeing tag along.


Matthew Castanien

Sent from my phone

I have discovered that the data I have in racktables is not consistent. In particular rows do not show up in the rack view that cna be found by searching for things in that row. I believe that the problem is related to an upgrade in the past that had issues.
Question: Is there a way to dump data out and then load into a fresh install? I am not worried about 100% conversion, but 80% would svae an incredible amount of time.
Suggestions?
--
Isaac Traxler AIX,Linux Admin
High Performance Computing 225-578-1923
Storage & Infrastructure

[Isaac W Traxler]

A database dump and reload would not solve the problem. The problems would
continue.

Basically some of the links that need to exist are broken. While I can
find some of them and make things better, I suspect it will always have
issues. The best answer is to start over. I am looking for a way to start
over without having to manually enter everything.

I suspect htis is not possible though. Because of the creation of local
values/fields/etc... It would probably be impossible.

Any ideas?

--
Isaac Traxler AIX,Linux Admin
Louisiana State University, LONI traxler-AGZSo6uS0+***@public.gmane.org
High Performance Computing 225-578-1923
Storage & Infrastructure

Date: Sat, 1 Mar 2014 07:09:39
Subject: [racktables-users] Re: Reload question
Are you looking for a database dump? If so use mysqldump. Example steps below.
Take backup.
mysqldump -u racktables-db-owner -p racktables-db-name > /tmp/racktables_db_YYYYMMDD_HHMMSS.sql
Go to machine with fresh install and create blank DB.
mysql> create database racktables;
Import data into blank DB.
mysql -u racktables-db-owner -p racktables-db-name < /tmp/racktables_db_YYYYMMDD_HHMMSS.sql
Point fresh install at this database and hit URL.
I'm curious to know if the issues you are seeing tag along.
Matthew Castanien
Sent from my phone

I have discovered that the data I have in racktables is not consistent. In particular rows do not show up in the rack view that cna be found by searching for things in that row. I believe that the problem is related to an upgrade in the past that had issues.
Question: Is there a way to dump data out and then load into a fresh install? I am not worried about 100% conversion, but 80% would svae an incredible amount of time.
Suggestions?
--
Isaac Traxler AIX,Linux Admin
High Performance Computing 225-578-1923
Storage & Infrastructure

[Olivier Contant]

You would need to analyse the database directly and to create your own tools to dig the data out and reinserted it correctly. It's a data analysis job.

Olivier Contant
System Administrator, Triton Digital

1440 Ste-Catherine W., Suite 1200 | Montreal, Qc, H3G 1R8
Tel.: [phone] #2771 | Toll-Free: +1.866.448.4037 #2771
olivier.contant-E1KE2KydfmkNIbNsV2NXlwC/***@public.gmane.org



-----Original Message-----
From: racktables-users-bounce-***@public.gmane.org [mailto:racktables-users-***@freelists.org] On Behalf Of Isaac W Traxler
Sent: Wednesday, March 12, 2014 11:02 AM
To: racktables-users-***@public.gmane.org
Subject: [racktables-users] Re: Reload question

A database dump and reload would not solve the problem. The problems would continue.

Basically some of the links that need to exist are broken. While I can find some of them and make things better, I suspect it will always have issues. The best answer is to start over. I am looking for a way to start over without having to manually enter everything.

I suspect htis is not possible though. Because of the creation of local values/fields/etc... It would probably be impossible.

Any ideas?

--
Isaac Traxler AIX,Linux Admin
Louisiana State University, LONI traxler-AGZSo6uS0+***@public.gmane.org
High Performance Computing 225-578-1923
Storage & Infrastructure

Date: Sat, 1 Mar 2014 07:09:39
Subject: [racktables-users] Re: Reload question
Are you looking for a database dump? If so use mysqldump. Example steps below.
Take backup.
mysqldump -u racktables-db-owner -p racktables-db-name >
/tmp/racktables_db_YYYYMMDD_HHMMSS.sql
Go to machine with fresh install and create blank DB.
mysql> create database racktables;
Import data into blank DB.
mysql -u racktables-db-owner -p racktables-db-name <
/tmp/racktables_db_YYYYMMDD_HHMMSS.sql
Point fresh install at this database and hit URL.
I'm curious to know if the issues you are seeing tag along.
Matthew Castanien
Sent from my phone

I have discovered that the data I have in racktables is not consistent. In particular rows do not show up in the rack view that cna be found by searching for things in that row. I believe that the problem is related to an upgrade in the past that had issues.
Question: Is there a way to dump data out and then load into a fresh install? I am not worried about 100% conversion, but 80% would svae an incredible amount of time.
Suggestions?
--
Isaac Traxler AIX,Linux Admin
High Performance Computing 225-578-1923
Storage & Infrastructure

[Denis Ovsienko]

Post by Isaac W Traxler
I have discovered that the data I have in racktables is not consistent. In
particular rows do not show up in the rack view that cna be found by
searching for things in that row. I believe that the problem is related to
an upgrade in the past that had issues.

Could you explain the problem in more detail?

-- 
    Denis Ovsienko

[Isaac W Traxler]

I have rack rows that do not show up on the rackspace page (and hence
racks that do not show). If I search on an objet in one of those racks, I
can see the object and the rack.

Any new rows I create do not show up. I believe all of this goes back to
an upgrade problem about 3 years ago. Unfortunately, I have a lot of data
in racktables -- this will be a royal pain.

I wold gladly accept suggestions if anyone has any.

--
Isaac Traxler AIX,Linux Admin
Louisiana State University, LONI traxler-AGZSo6uS0+***@public.gmane.org
High Performance Computing 225-578-1923
Storage & Infrastructure

Date: Wed, 26 Mar 2014 09:10:20
Subject: [racktables-users] Re: Reload question

Post by Isaac W Traxler
I have discovered that the data I have in racktables is not consistent. In
particular rows do not show up in the rack view that cna be found by
searching for things in that row. I believe that the problem is related to
an upgrade in the past that had issues.

Could you explain the problem in more detail?
--š
ššš Denis Ovsienko

[Denis Ovsienko]

Post by Isaac W Traxler
I have rack rows that do not show up on the rackspace page (and hence
racks that do not show). If I search on an objet in one of those racks, I
can see the object and the rack.
Any new rows I create do not show up. I believe all of this goes back to
an upgrade problem about 3 years ago. Unfortunately, I have a lot of data
in racktables -- this will be a royal pain.

This resembles the behaviour of a normal rackspace view with a tag filter applied. Could you confirm the tag filter is clear when this happens?

Post by Isaac W Traxler
I wold gladly accept suggestions if anyone has any.

The least destructive way seems to be to reset all rack rows to belong to one location (or no location) by means of an SQL UPDATE. Do you have a copy of the database to do the test?

-- 
    Denis Ovsienko