[Met_help] [rt.rap.ucar.edu #80726] History for database table removal

[Tatiana Burek via RT]

----------------------------------------------------------------
  Initial Request
----------------------------------------------------------------

I would like to drop some tables from the mysql database.  Right now I put
in every single variable into the mysql database for my database
mv_emc_g2o.   I have a giant list:  BCSVR, BCSVR2, CAPE, CEILING, CHILL,
etc, etc, etc.

Say I wanted to drop everything except for things like Z, T, DPT, U, V, and
a few others and drop everything else. I wish to do a mysqldump to save the
variables I want to drop and then drop them.  (I think a variable is a
table, right?)

Can you send me the instructions (exact commands) for the following:

1)  Save the variables I want to drop to a file using mysqldump
2)  Drop these variables from the file
3)  Modify my xml loading script so I only load the variables I want to save

I think this would help me free up a lot of space on the server.

Thanks!

Perry


----------------------------------------------------------------
  Complete Ticket History
----------------------------------------------------------------

Subject: database table removal
From: Tatiana Burek
Time: Fri Jun 02 13:35:17 2017

Perry,

I can help you with #1 (dumping certain rows into the file) and #2
(removing certain rows from the database tables).

#3.... Is your data contain multiple variables in a single file or
each variable has its own file and  this file is stored under the
directory with the name containing the variable name? Ex:

/d1/test/TMP/file1.vsdb
/d1/test/TMP/file2.vsdb
where file1 and file2 have data for TMP only.

If you have this structure - I can help you with the loading XML file.
In other cases - METViewer doesn't have an interface to load only
specified fields. It loads all lines from the file.

Tatiana

On Fri Jun 02 10:16:39 2017, perry.shafran at noaa.gov wrote:
> I would like to drop some tables from the mysql database.  Right now
I put
> in every single variable into the mysql database for my database
> mv_emc_g2o.   I have a giant list:  BCSVR, BCSVR2, CAPE, CEILING,
CHILL,
> etc, etc, etc.
>
> Say I wanted to drop everything except for things like Z, T, DPT, U,
V, and
> a few others and drop everything else. I wish to do a mysqldump to
save the
> variables I want to drop and then drop them.  (I think a variable is
a
> table, right?)
>
> Can you send me the instructions (exact commands) for the following:
>
> 1)  Save the variables I want to drop to a file using mysqldump
> 2)  Drop these variables from the file
> 3)  Modify my xml loading script so I only load the variables I want
to save
>
> I think this would help me free up a lot of space on the server.
>
> Thanks!
>
> Perry



------------------------------------------------
Subject: database table removal
From: perry.shafran at noaa.gov
Time: Fri Jun 02 13:41:46 2017

Hi, Tatiana,

Ah, METViewer can only load specified fields.  In that case I would
probably need to further trim down my VSDB files to only the variables
that
I am choosing and not have the variables I don't.

In that case, if I can have the instructions for 1 and 2, that would
be
great and I'll work on trimming the files.

Perry

On Fri, Jun 2, 2017 at 3:35 PM, Tatiana Burek via RT
<met_help at ucar.edu>
wrote:

> Perry,
>
> I can help you with #1 (dumping certain rows into the file) and #2
> (removing certain rows from the database tables).
>
> #3.... Is your data contain multiple variables in a single file or
each
> variable has its own file and  this file is stored under the
directory with
> the name containing the variable name? Ex:
>
> /d1/test/TMP/file1.vsdb
> /d1/test/TMP/file2.vsdb
> where file1 and file2 have data for TMP only.
>
> If you have this structure - I can help you with the loading XML
file.
> In other cases - METViewer doesn't have an interface to load only
> specified fields. It loads all lines from the file.
>
> Tatiana
>
> On Fri Jun 02 10:16:39 2017, perry.shafran at noaa.gov wrote:
> > I would like to drop some tables from the mysql database.  Right
now I
> put
> > in every single variable into the mysql database for my database
> > mv_emc_g2o.   I have a giant list:  BCSVR, BCSVR2, CAPE, CEILING,
CHILL,
> > etc, etc, etc.
> >
> > Say I wanted to drop everything except for things like Z, T, DPT,
U, V,
> and
> > a few others and drop everything else. I wish to do a mysqldump to
save
> the
> > variables I want to drop and then drop them.  (I think a variable
is a
> > table, right?)
> >
> > Can you send me the instructions (exact commands) for the
following:
> >
> > 1)  Save the variables I want to drop to a file using mysqldump
> > 2)  Drop these variables from the file
> > 3)  Modify my xml loading script so I only load the variables I
want to
> save
> >
> > I think this would help me free up a lot of space on the server.
> >
> > Thanks!
> >
> > Perry
>
>
>
>

------------------------------------------------
Subject: database table removal
From: perry.shafran at noaa.gov
Time: Tue Jun 06 07:02:12 2017

Hi, again, Tatiana,

Do you have the commands that will allow me to do 1 and 2 from above?
Will
that help me save space from the mysql database?

Thanks!

Perry

On Fri, Jun 2, 2017 at 3:35 PM, Tatiana Burek via RT
<met_help at ucar.edu>
wrote:

> Perry,
>
> I can help you with #1 (dumping certain rows into the file) and #2
> (removing certain rows from the database tables).
>
> #3.... Is your data contain multiple variables in a single file or
each
> variable has its own file and  this file is stored under the
directory with
> the name containing the variable name? Ex:
>
> /d1/test/TMP/file1.vsdb
> /d1/test/TMP/file2.vsdb
> where file1 and file2 have data for TMP only.
>
> If you have this structure - I can help you with the loading XML
file.
> In other cases - METViewer doesn't have an interface to load only
> specified fields. It loads all lines from the file.
>
> Tatiana
>
> On Fri Jun 02 10:16:39 2017, perry.shafran at noaa.gov wrote:
> > I would like to drop some tables from the mysql database.  Right
now I
> put
> > in every single variable into the mysql database for my database
> > mv_emc_g2o.   I have a giant list:  BCSVR, BCSVR2, CAPE, CEILING,
CHILL,
> > etc, etc, etc.
> >
> > Say I wanted to drop everything except for things like Z, T, DPT,
U, V,
> and
> > a few others and drop everything else. I wish to do a mysqldump to
save
> the
> > variables I want to drop and then drop them.  (I think a variable
is a
> > table, right?)
> >
> > Can you send me the instructions (exact commands) for the
following:
> >
> > 1)  Save the variables I want to drop to a file using mysqldump
> > 2)  Drop these variables from the file
> > 3)  Modify my xml loading script so I only load the variables I
want to
> save
> >
> > I think this would help me free up a lot of space on the server.
> >
> > Thanks!
> >
> > Perry
>
>
>
>

------------------------------------------------