From dougsland at redhat.com Mon Apr 2 10:13:16 2012 Content-Type: multipart/mixed; boundary="===============3331174609063512327==" MIME-Version: 1.0 From: Douglas Landgraf To: devel at ovirt.org Subject: Re: [Engine-devel] Backing up the DB Date: Mon, 02 Apr 2012 11:19:23 -0400 Message-ID: <4F79C37B.3070707@redhat.com> In-Reply-To: 20120402132058.GG11957@aglitke.ibm.com --===============3331174609063512327== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable This is a multi-part message in MIME format. --------------050901030201090108020804 Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed Content-Transfer-Encoding: 7bit Hi, On 04/02/2012 09:20 AM, Adam Litke wrote: > Hi all, > > I have a working development environment for ovirt-engine and I want to v= erify > someone else's gerrit change. Is there a documented proceedure for backi= ng up > the engine db so that, after checking out the new code and updating the db > schema, I can revert to my old code and DB (schema and data). Thanks! > Usually I use this tool to backup/restore db: https://github.com/dougsland/misc-rhev/blob/master/rhevm-db-tool.py However, since it's "rhevm" db tool.. need manually change the db name = to "engine", I will rename it to engine-db-tool and update the code to 'engine' soon.. -- = Cheers Douglas --------------050901030201090108020804 Content-Type: text/html; charset=3DISO-8859-1 Content-Transfer-Encoding: 7bit Hi,

On 04/02/2012 09:20 AM, Adam Litke wrote: 
Hi all,

I have a working development environment for ovirt-engine and I want to ver=
ify
someone else's gerrit change.  Is there a documented proceedure for backing=
 up
the engine db so that, after checking out the new code and updating the db
schema, I can revert to my old code and DB (schema and data).  Thanks!
Usually I use this tool to backup/restore db:
https://github.com/dougsland/misc-rhev/blob/master/rhevm-db-tool.py
However, since it's "rhevm" db tool.. need manually change the db name to "engine",
I will rename it to engine-db-tool and update the code to 'engine' soon..

-- =

Cheers
Douglas
--------------050901030201090108020804-- --===============3331174609063512327== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4KLS0tLS0tLS0tLS0t LS0wNTA5MDEwMzAyMDEwOTAxMDgwMjA4MDQKQ29udGVudC1UeXBlOiB0ZXh0L3BsYWluOyBjaGFy c2V0PUlTTy04ODU5LTE7IGZvcm1hdD1mbG93ZWQKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzog N2JpdAoKSGksCgpPbiAwNC8wMi8yMDEyIDA5OjIwIEFNLCBBZGFtIExpdGtlIHdyb3RlOgo+IEhp IGFsbCwKPgo+IEkgaGF2ZSBhIHdvcmtpbmcgZGV2ZWxvcG1lbnQgZW52aXJvbm1lbnQgZm9yIG92 aXJ0LWVuZ2luZSBhbmQgSSB3YW50IHRvIHZlcmlmeQo+IHNvbWVvbmUgZWxzZSdzIGdlcnJpdCBj aGFuZ2UuICBJcyB0aGVyZSBhIGRvY3VtZW50ZWQgcHJvY2VlZHVyZSBmb3IgYmFja2luZyB1cAo+ IHRoZSBlbmdpbmUgZGIgc28gdGhhdCwgYWZ0ZXIgY2hlY2tpbmcgb3V0IHRoZSBuZXcgY29kZSBh bmQgdXBkYXRpbmcgdGhlIGRiCj4gc2NoZW1hLCBJIGNhbiByZXZlcnQgdG8gbXkgb2xkIGNvZGUg YW5kIERCIChzY2hlbWEgYW5kIGRhdGEpLiAgVGhhbmtzIQo+ClVzdWFsbHkgSSB1c2UgdGhpcyB0 b29sIHRvIGJhY2t1cC9yZXN0b3JlIGRiOgpodHRwczovL2dpdGh1Yi5jb20vZG91Z3NsYW5kL21p c2Mtcmhldi9ibG9iL21hc3Rlci9yaGV2bS1kYi10b29sLnB5CgpIb3dldmVyLCBzaW5jZSBpdCdz ICJyaGV2bSIgZGIgdG9vbC4uIG5lZWQgbWFudWFsbHkgY2hhbmdlIHRoZSBkYiBuYW1lIAp0byAi ZW5naW5lIiwKSSB3aWxsIHJlbmFtZSBpdCB0byBlbmdpbmUtZGItdG9vbCBhbmQgdXBkYXRlIHRo ZSBjb2RlIHRvICdlbmdpbmUnIHNvb24uLgoKLS0gCkNoZWVycwpEb3VnbGFzCgoKLS0tLS0tLS0t LS0tLS0wNTA5MDEwMzAyMDEwOTAxMDgwMjA4MDQKQ29udGVudC1UeXBlOiB0ZXh0L2h0bWw7IGNo YXJzZXQ9SVNPLTg4NTktMQpDb250ZW50LVRyYW5zZmVyLUVuY29kaW5nOiA3Yml0Cgo8aHRtbD4K ICA8aGVhZD4KICAgIDxtZXRhIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD1JU08tODg1OS0x IgogICAgICBodHRwLWVxdWl2PSJDb250ZW50LVR5cGUiPgogIDwvaGVhZD4KICA8Ym9keSBiZ2Nv bG9yPSIjRkZGRkZGIiB0ZXh0PSIjMDAwMDAwIj4KICAgIEhpLDxicj4KICAgIDxicj4KICAgIE9u IDA0LzAyLzIwMTIgMDk6MjAgQU0sIEFkYW0gTGl0a2Ugd3JvdGU6CiAgICA8YmxvY2txdW90ZSBj aXRlPSJtaWQ6MjAxMjA0MDIxMzIwNTguR0cxMTk1N0BhZ2xpdGtlLmlibS5jb20iCiAgICAgIHR5 cGU9ImNpdGUiPgogICAgICA8cHJlIHdyYXA9IiI+SGkgYWxsLAoKSSBoYXZlIGEgd29ya2luZyBk ZXZlbG9wbWVudCBlbnZpcm9ubWVudCBmb3Igb3ZpcnQtZW5naW5lIGFuZCBJIHdhbnQgdG8gdmVy aWZ5CnNvbWVvbmUgZWxzZSdzIGdlcnJpdCBjaGFuZ2UuICBJcyB0aGVyZSBhIGRvY3VtZW50ZWQg cHJvY2VlZHVyZSBmb3IgYmFja2luZyB1cAp0aGUgZW5naW5lIGRiIHNvIHRoYXQsIGFmdGVyIGNo ZWNraW5nIG91dCB0aGUgbmV3IGNvZGUgYW5kIHVwZGF0aW5nIHRoZSBkYgpzY2hlbWEsIEkgY2Fu IHJldmVydCB0byBteSBvbGQgY29kZSBhbmQgREIgKHNjaGVtYSBhbmQgZGF0YSkuICBUaGFua3Mh Cgo8L3ByZT4KICAgIDwvYmxvY2txdW90ZT4KICAgIFVzdWFsbHkgSSB1c2UgdGhpcyB0b29sIHRv IGJhY2t1cC9yZXN0b3JlIGRiOjxicj4KICAgIDxtZXRhIGh0dHAtZXF1aXY9ImNvbnRlbnQtdHlw ZSIgY29udGVudD0idGV4dC9odG1sOwogICAgICBjaGFyc2V0PUlTTy04ODU5LTEiPgogICAgPGEK aHJlZj0iaHR0cHM6Ly9naXRodWIuY29tL2RvdWdzbGFuZC9taXNjLXJoZXYvYmxvYi9tYXN0ZXIv cmhldm0tZGItdG9vbC5weSI+aHR0cHM6Ly9naXRodWIuY29tL2RvdWdzbGFuZC9taXNjLXJoZXYv YmxvYi9tYXN0ZXIvcmhldm0tZGItdG9vbC5weTwvYT48YnI+CiAgICA8YnI+CiAgICBIb3dldmVy LCBzaW5jZSBpdCdzICJyaGV2bSIgZGIgdG9vbC4uIG5lZWQgbWFudWFsbHkgY2hhbmdlIHRoZSBk YgogICAgbmFtZSB0byAiZW5naW5lIiw8YnI+CiAgICBJIHdpbGwgcmVuYW1lIGl0IHRvIGVuZ2lu ZS1kYi10b29sIGFuZCB1cGRhdGUgdGhlIGNvZGUgdG8gJ2VuZ2luZScKICAgIHNvb24uLjxicj4K ICAgIDxicj4KICAgIDxwcmUgY2xhc3M9Im1vei1zaWduYXR1cmUiIGNvbHM9IjcyIj4tLSAKQ2hl ZXJzCkRvdWdsYXM8L3ByZT4KICA8L2JvZHk+CjwvaHRtbD4KCi0tLS0tLS0tLS0tLS0tMDUwOTAx MDMwMjAxMDkwMTA4MDIwODA0LS0K --===============3331174609063512327==--