Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] problem running grouper on copy of its database

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] problem running grouper on copy of its database


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Baron Fujimoto <>
  • Cc: Julio Polo <>, " Mailing List" <>
  • Subject: RE: [grouper-users] problem running grouper on copy of its database
  • Date: Wed, 24 May 2017 22:28:44 +0000
  • Accept-language: en-US
  • Authentication-results: hawaii.edu; dkim=none (message not signed) header.d=none;hawaii.edu; dmarc=none action=none header.from=isc.upenn.edu;
  • Ironport-phdr: 9a23:drjovh+kkZBZJv9uRHKM819IXTAuvvDOBiVQ1KB20ugcTK2v8tzYMVDF4r011RmSDNqdsKgP0rGempujcFRI2YyGvnEGfc4EfD4+ouJSoTYdBtWYA1bwNv/gYn9yNs1DUFh44yPzahANS47xaFLIv3K98yMZFAnhOgppPOT1HZPZg9iq2+yo9ZDeZwdFiCCzbL9sIxm6sAvcvdQKjIV/Lao81gHHqWZSdeRMwmNoK1OTnxLi6cq14ZVu7Sdete8/+sBZSan1cLg2QrJeDDQ9LmA6/9brugXZTQuO/XQTTGMbmQdVDgff7RH6WpDxsjbmtud4xSKXM9H6QawyVD+/9KpgVgPmhzkbOD446GHXi9J/jKRHoBK6uhdzx5fYbJyJOPZie6/Qe84RS2hcUcZLTyFPAp2yYZYTD+QPPuhYoYvyp1oSohWxCgahH//vxSRUinPqwaE2z+YsHAfb1wIgBdIOt3HUoc37OKkQUeG0zbfHzS/bY/hLxzr96JLIchE6of2CQLl9ds/RxlUvFwLFj1Sft5blMiiU1uQWr2eX9fdgVfqxhG4hrQF9uCagydoxioTQgI8e11PK9T1hzYorP9K0VFN3bNu5HJdNqi2XMoV2T8w+T210vSs3yKMJtJG0cSUPzZkr2QLTZvKff4SV7B/vSPydLDNliH5/Zr6zmhK//VK9xuD+V8S51ktBoDBfndnWrH8N0gTe6siZRft5+UeswS6B2hzU5O1YP0w4jLfVJYY8zrIpkZocqlrMEjXxmEXrkK+ZbUIk+vWu6+v6eLnmvoWcN4hoig7gLqsuhs2/AeM+MgQUWGib5Pi81Lnk/U3+Q7VGlOE5kq7csJzCJMQboLC2AxNN34o98RmzEyqq3dEFkXUaMV5IfRyHgof1N13SJf31D+mwjlujnTpuwv3KIKHtD5vVInjGirjhfLJ960BGyAo0yNBS/5dUBa0BIPPzW07+qsbYAwQ4Mwyv3+nrEsh91psAVmKJBK+VKr3dvkKV5u43OemDeJcVuCrhK/gi//PugmU5mVgAfamxw5QXcmm0Hul9I0qHe3rsmcwMEWMLvgolUOzqk0OOXSRSZ3a0Q6Iz+Cs7CIS4AoffWIyhmqKO0zqmHs4eWmcTIFmWFnGgWZiGWvILdCXadsVoiDsCfbioVIYg1FejuBKsmJR9Ke+BsA0Jp5/5kJBe5/fSjlt6oTl/D9WP3nulTnp/2H4QSjkwmq1zvBoumR+4zaFkjqkARpRo7PRTX1J/bMaEwg==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99
Let me see if I can find all your questions...

I think disable keys looks right.


> For each table, surround the INSERT statements with statements to disable
> and enable keys" is close to that and is a default. See attached screencap.

Yes


> My method differed in that rather than doing 3) I would import (run) the
> SQL file(s) resulting from the export. A review of the SQL files revealed
> that they DROP/CREATE TABLE for each of the required tables.


> If I create the DB with 3a) 3b), won't these exported SQL files just drop
> and recreate the tables?

When I did it with mysql and views and foreign keys it didn’t do it right.
So that is why I suggested to have Grouper do this, then truncate all tables
:)


> When exporting/dumping the DB, the options are to:
> - Dump Structure and Data
> - Dump Data Only
> - Dump Structure Only
>
> I have been using Dump Structure and Data. Should I be dumping just data?

Yes

> Should the dump only be taken from a quiesced DB with no grouper processes
> or activity occuring?

I think it is best to take a dump when no other activity is occurring...

Thanks
Chris

Archive powered by MHonArc 2.6.19.

Top of Page